Newbie VBA Programming Trouble

  • Thread starter Thread starter David M
  • Start date Start date
D

David M

Frustration has set it....got some real good sugestions
from you guys but I am having troubles with syntax....

I want to be able to select the following: H2 thru AE2
then copy down to H3 thru AE3.....using code to do this,
so I won't have to manually do it with each record
entered...this will copy all the formulas in H3 thru AE3
down to the next row....I want to take that code and
attach it to a button so after each entry I can just click
and excel will copy...

I have trouble writing it using examples I know...slow
Newbie...

Thanx again for your patience and help,,,,

:)
 
Hi
try to record a macro while doing this manually and assign this macro
to a button
 
David

It may be easier to just select row 2 and Insert>Row.

But, if you have data in Columns A through G you don't want moved, select
H2:AE2 and Insert Cells>Shift Down.

Sub Shift_Down()
With Range("H2:AE2")
.Insert Shift:=xlDown
End With
End Sub

Gord Dibben Excel MVP
 
Back
Top