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!
|