Newbie VBA Programming Trouble

[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,,,,

 

[Frank Kabel]

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

 

[Gord Dibben]

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

 

[david M]

I tried that but it does not go to the next record to copy
down from there...

D