VBA coding

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

Hi

the easiest way to access your macros to edit them is to choose tools /
macro / macros, click on the macro you want to edit and press the EDIT
button - you'll be taken directly to the appropriate code.
(to get back to the workbook you can either close the code window, using the
top X or use ALT & F11 to switch back and forth between the VBE Window & the
workbook).

Cheers
JulieD
 
Hi everyone

I am very new to vba coding. Though time to time I record macros. Some I
want to edit my macro but I don't the vba codes. It there a place where all
the codes/coomanda are stored.

thanks
Nadeem
 
right click on sheet tab>view code>insert this>save.
Now, when you enter anything in column F (6) a row will be inserted

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 Then Target.EntireRow.Insert
End Sub
 
Back
Top