Selet Syntax

  • Thread starter Thread starter William Wolfe
  • Start date Start date
W

William Wolfe

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,
 
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
 
Back
Top