View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rex Dunlap Rex Dunlap is offline
external usenet poster
 
Posts: 3
Default Selecting Data in Column

The following code gets the last data cell in column B:
Range("b20000").End(xlUp).Select

I would now like to select the Range("Activecell:B2"). How
do I do that?

Thank you for your help.