Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Complete code to work on various sheets, each having exact same columns, but
varying number of rows. All cells in Columns A thru I have data J and K columns are empty, at this point How to move from a given point (active cell), to another cell without referencing actual cell row locations ( K?), or (J?) ' Go to column C, end, Insert TOTALS ' this one works Range("C1").Select Selection.End(xlDown).Select ActiveCell.FormulaR1C1 = "TOTALS" ' Move right 7 Cells, to "J" Range ("J?").Select Range("J?").Formula = "=(+I201-G201)/G201-1 ' Move RIGHT 8 Cells to "K" Range("K?").Select ActiveCell.FormulaR1C1 = "%" ' Select the bottom used cells and format Range("C?:K?").Select Selection.Font.Bold = True Selection.Font.Size = 12 With Selection .HorizontalAlignment = xlCenter End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Active cell position for macro | Excel Worksheet Functions | |||
In macros, an instruction that will return the position of the Active Cell | Excel Programming | |||
Why does cursor move position in a cell I'm trying to edit? | Excel Discussion (Misc queries) | |||
Macro to move first name to last position in cell | Excel Programming | |||
Active Cell Position Using Go To Or Hyperlink | Excel Programming |