Moving Range Selection Right One Column at a Time

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Post my named ranges in column A 10
Adjust code to run anywhere on sheet 3
Multiple Dynamic Named Ranges across Columns 3
Delete rows based on contents of Col A 0
Range passed to a function - trying to just move through the range 4
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Macro needs updated Range name addresses 3
Import multiple workbooks to current workbook in specified row number 0

Top