View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Find the beginning Cell of a Range

Dim myRng as range
dim myCell as range

'somewhat the user defines myRng

set mycell = myrng.cells(1)



J@Y wrote:

I have a user input a range, how can I store the beginning cell of that range
in a variable?


--

Dave Peterson