ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving Range Selection Right One Column at a Time (https://www.excelbanter.com/excel-programming/348370-moving-range-selection-right-one-column-time.html)

TexDad

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.

bpeltzer

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.


TexDad

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