Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Easy cell referencing question

Status
Not open for further replies.

pdbowling

Programmer
Mar 28, 2003
267
US
Hi everyone.
I want to have a macro walk across the columns of a spreadsheet using column numbers instead of letter references. I can't remember the syntax for this. Anybody got a minute to refresh my memory?

Cell "C2" would be (2,3)...... etc.

Thanks so much everyone.
PB
 
Cells(Row_Number,Column_Number).select

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
 
Thanks guys, that was a little more obvious than I was thinking but simple none the less.
PB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top