| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Clean Up Code - consolidate steps
Hi All...
I have code that contains the following: ActiveCell.FormulaR1C1 = "USB" Range("A2").Select ActiveCell.FormulaR1C1 = "04165" Range("A3").Select ActiveCell.FormulaR1C1 = "14709" Range("A4").Select ActiveCell.FormulaR1C1 = "14716" Range("A5").Select ActiveCell.FormulaR1C1 = "24704" Range("A6").Select ActiveCell.FormulaR1C1 = "44705" Range("A7").Select ActiveCell.FormulaR1C1 = "44710" and it goes on to enter the associated text on the next line...all the way down to 60 rows. Is there a way that I can consolidate these steps where the macro will automatically know to put the text in the next rows......for example.... MACRO CODE = Enter Text, start A1...FAS,12354, 23456 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Threaded Mode
