View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Hopson Bob Hopson is offline
external usenet poster
 
Posts: 11
Default Using symbolic in Excel Macro

Thanks for the suggestion. I'll give it a try.

Regards,

Bob

"okrob" wrote:

x = ActiveSheet.UsedRange.Cells(ActiveSheet.UsedRange. Cells.Count).Row
Range("BE1:BE" & x).Select