Thread: Range with numerical data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Range with numerical data
Use this

Range("A" & count1 & ":D" & count2).Select



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Moises" wrote in message ...

What would be the correct code for the following range :

Range A12:D24

count1= 12
count2=24

I am writing the following , but it does not work :
Range ( "A & count1 : D" & count2).Select

Thanks,

Moises


Reply With QuoteReply With Quote