new to macros. what is the following statement doing...

[alarge23]

I have never used Excel macros before. I am trying to figure out what the following statement is doing:

Application.Goto Reference:="R6C2"

Where is 'R6C2' on my spreadsheet?

 

[xlhelp]

It's six rows down and two columns right from where the cursor is.

http://www.geniusmedia.ca

 

[GlennUK]

Erm .. xlhelp, you've got it a bit wrong there. It's going to the sixth row, and second column of the sheet, irrespective of where the current cell is.

Now, Application.Goto Reference:="R[6]C[2]" would do what you said.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.