Thread: Need to Select multiple cells based on counter
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
  
Posts: 226
Default Need to Select multiple cells based on counter
I find it easier to use the Cells() object, something like

Cells(myrownumber, mycolumnnumber)

--
Regards

Juan Pablo González

"Skyron " wrote in message
...
Hey,

I'm having trouble finding how to make a selection of cells using
integer values rather than text

i.e.
Range("A1:A5")

Is there a way to use Range with integer values?
I need to make selections of cells based on an integer counter in a VBA
Script

Thanks!!!


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote