View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sugargenius@gmail.com is offline
external usenet poster
 
Posts: 2
Default worksheet range qualifier

Are the last 2 statements equivalent?

Dim oReportSheet As Worksheet
oReportSheet = Worksheets.Add
oReportSheet.Range(Cells(1, 1), Cells(1,
7)).Columns.EntireColumn.AutoFit
Range(oReportSheet.Cells(1, 1), oReportSheet.Cells(1,
7)).Columns.EntireColumn.AutoFit

What if the oReportSheet sheet weren't active. Would that matter?