Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet range qualifier
On Dec 14, 2:11 pm, "
wrote: 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? They are if oReportSheet is active. So are Range(Cells(1, 1), Cells(1, 7)).Columns.EntireColumn.AutoFit and Activesheet.Range(Cells(1, 1), Cells(1, 7)).Columns.EntireColumn.AutoFit If oReportSheet is not active, or may not be, the neatest syntax to use is With oReportSheet .Range(.Cells(1, 1), .Cells(1, 7)).Columns.EntireColumn.AutoFit end With note the dots before Range and Cells. you must fully qualify the range reference with the sheet object. regards Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet range qualifier
On Dec 14, 9:24 am, wrote:
On Dec 14, 2:11 pm, " wrote: 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? They are if oReportSheet is active. So are Range(Cells(1, 1), Cells(1, 7)).Columns.EntireColumn.AutoFit and Activesheet.Range(Cells(1, 1), Cells(1, 7)).Columns.EntireColumn.AutoFit If oReportSheet is not active, or may not be, the neatest syntax to use is With oReportSheet .Range(.Cells(1, 1), .Cells(1, 7)).Columns.EntireColumn.AutoFit end With note the dots before Range and Cells. you must fully qualify the range reference with the sheet object. regards Paul thanks, Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need qualifier statement | Excel Worksheet Functions | |||
Invalid Qualifier | Excel Programming | |||
IF function using a dates as the qualifier.. | Excel Worksheet Functions | |||
Invalid Qualifier??? | Excel Programming |