![]() |
Moving Range Selection Right One Column at a Time
I want to succesively name ranges in a table by starting in column A for a
dynamic number of rows, naming that range and then moving over to the next column (same rows) and naming that next range. I'm stuck on how to move the selection over one column. Simple task but this novice is stuck. |
Moving Range Selection Right One Column at a Time
selection.offset(0,1).select
"TexDad" wrote: I want to succesively name ranges in a table by starting in column A for a dynamic number of rows, naming that range and then moving over to the next column (same rows) and naming that next range. I'm stuck on how to move the selection over one column. Simple task but this novice is stuck. |
Moving Range Selection Right One Column at a Time
Worked perfectly! THX.
"bpeltzer" wrote: selection.offset(0,1).select "TexDad" wrote: I want to succesively name ranges in a table by starting in column A for a dynamic number of rows, naming that range and then moving over to the next column (same rows) and naming that next range. I'm stuck on how to move the selection over one column. Simple task but this novice is stuck. |
All times are GMT +1. The time now is 08:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com