| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
just trying to copy 6 rows to the right
I know this is a basic question, but I haven't used excel vb in years
so I'm trying to get some of the dust off. I have the following vb code to copy a footer cell (which was used to sum the contents of the column above it) and paste it to the 6 cells to the right. Range("E154").Select Selection.Copy Range("F154:L154").Select ActiveSheet.Paste I just want to make this a relative formula. After a few of these, I'll start to get the swing of things again. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change a Macro - Copy in Columns instead of copy in Rows | Excel Programming | |||
| Copy pasting Rows, but need to Delete any Shapes/Pictures that are within copied rows | Excel Programming | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Find all rows of a color and copy those rows to a new worksheet | Excel Programming | |||
| Copy Rows and insert these rows before a page break | Excel Programming | |||
Threaded Mode
