View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron5440 Ron5440 is offline
external usenet poster
 
Posts: 16
Default Use memory variable in range selection

My range always starts at B12 but it varies in depth.
After I find the bottom right I need to select to the top left
x = ActiveCell.Address
Range("b12":"x").Select
I did this a couple of years ago in another piece of code but cannot find an
example of it and don't remember how I did it.
I am still searching...if anyone has a quick piece of code it would be
appreciated.

Thnks,
Ron