View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default referring by index to adjacent cells

Hi
one way:
cells(r,1).resize(1,2).select

--
Regards
Frank Kabel
Frankfurt, Germany


Demyan wrote:
Hi,
I need to repeatedly select a cell by its index (e.g. Cells(r,1) with
a loop over r), and merge it with the cell to the right. Could you
please tell me how it can be done? (Can I select the cell, and then
expand Selection to the right?)
Thank you very much!