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, |
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 |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com