Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selet Syntax
I am trying to select a cell with the following statement:
Detail_Report.Cells(61, Column).Select This doesn't work. The .Range works, but I cannot define it using row.column indicies. How do I resolve this? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selet Syntax
First I wouldn't use Column as a variable name. Excel uses it already.
Maybe it's because Detail_Report isn't the activesheet or the workbook that holds Detail_Report isn't the active workbook. dim myCol as long mycol = 32 with detail_report .parent.activate 'the workbook needs to be active, too. .select .cells(61, myCol).select end with William Wolfe wrote: I am trying to select a cell with the following statement: Detail_Report.Cells(61, Column).Select This doesn't work. The .Range works, but I cannot define it using row.column indicies. How do I resolve this? Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Syntax | Excel Discussion (Misc queries) | |||
Help with Syntax | Excel Discussion (Misc queries) | |||
Syntax help for if | Excel Programming | |||
AND if syntax | Excel Programming | |||
Syntax help! | Excel Programming |