Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to write a macro to select a cell, move to the end of the cell,
press enter, and move to the next cell in that row & then repeat for all rows in that column. Here's what I have so far. Range("A2").Select ActiveCell.FormulaR1C1 = "07-30365" Range("A3").Select ActiveCell.FormulaR1C1 = "07-40281" Range("A4").Select ActiveCell.FormulaR1C1 = "1272-00-02" Range("A5").Select ActiveCell.FormulaR1C1 = "1272-00-03" Range("A6").Select ActiveCell.FormulaR1C1 = "1272-00-04" Range("A7").Select ActiveCell.FormulaR1C1 = "1272-00-05" Range("A8").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I use code/macro to change code/macro in an existing file? | Excel Programming | |||
do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
Need help with code for Excel Macro | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming |