View Full Version : Col/Row Number of ActiveCell


RaunLGoode
10-18-2007, 08:53 AM
I want to assign the Column and Row number of the active cell of a worksheet to variables (Cnum, Rnum) but I can't find the right syntax
I was thinking it would be something like:
"Cnum = ActiveCell.(This is the part I don't know)

Could somebody enlighten me?

unmarkedhelicopter
10-18-2007, 10:28 AM
activecell.row
activecell.column