Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings. How can I use a column number in a range, instead of column
letters? For example, I have Range("B3:B7").Select. I want to copy and paste this range in another place in the worksheet, then run some other code, and then copy Range("C3:C7") and run some code, all the way up to Range("M3:M7"). I would like to be able to use a variable for the column index, then just increment it by 1 at the end of the loop. Any ideas? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
Column Number from Column Letter | Excel Programming | |||
Identify the column of a range by letter instead of number | Excel Programming | |||
Get Column Letter from Column Number | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) |