Can VBA read the row-col location of a selected cell?
Hi
selection.row and selection.column will give you the information you need
Anyway, you can reach the cell below by writing the instruction below if you
are on the activecell
activecell.offset(1,0).select
Regards
"news.bcentral.com" a écrit dans le message de
news: ...
I am trying to assign the row and column of a selected excel cell to a
variable name, then return from the VBA procedure to the cell directly
below
that cell...without much luck.
Can anybody help?
Thanks...James Hill
|