View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
david.carl david.carl is offline
external usenet poster
 
Posts: 1
Default 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