Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba copy number to Column as letter ' B '
Can anyone suggest a VBA macro in copying a number found in Column J
say, that number for that row is 5. Copy that number to Column 'E' (which is the fifth column, not the number 5 but the letter ' B '. Then proceed down to the next row in Column J which number is 1; copy number 1,then change to 'B' in column A. Do this until there are no more numbers in Column J. Background, Column J is the Bonus number in a lottery. This number is copied to the appropriate column as 'B'. Doing this all the while in VBA. With thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Column Number/Letter | Excel Programming | |||
Column Number to letter in Row Source | Excel Programming |