View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Thomas [PBD] Thomas [PBD] is offline
external usenet poster
 
Posts: 154
Default How do I use the .Cells property to refer to ActiveCell?

Caeres,

The way to do this would be to place the following code into the script.

Cells(ActiveCell.Row, ActiveCell.Column)

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"Caeres" wrote:

I need to refer to the active cell using the Cells property (eg
Range.Cells(...)). How do I do this?