Changing of Macros

N

Naas

How do I get Excel to automatically change/update macros
after I've added rows and/or columns in a spreadsheet
 
B

Bob Phillips

You don't, you cater for the variable length to begin with. For example,
this code

cRows = Cells(Rows.Count,"A").End(xlUp).Row

will return the number of rows that are used in column A, regardless of
whether new ones have just been added.

If you want more help, post back with more details of what you want to do.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

Jim May

will return the number of rows that are used in column A

Bob, I would have defined (to the OP) cRows as returning the last non-empty
row number in Column A. Am I being persnickety? <<vbg>>
Jim
 
G

Guest

Hi Ron,

This is one.

Hopes it is enough.

Regards,

Naas



Sub adddelivery()
'
' adddelivery Macro
' Macro recorded 2003/04/30 by Naas Vermaak
'

'
ActiveSheet.Unprotect
Sheets("FIXED INPUTS").Select
Range("A49:J49").Select
Selection.Copy
Sheets("DELIVERIES").Select
Range("B27").Select
Selection.insert Shift:=xlDown
Range("B46:K46").Select
Selection.Delete Shift:=xlUp
Range("C27").Select

End Sub





-----Original Message-----
Hi Naas

Post a example of your macro.
We can help you then


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Naas" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
B

Bob Phillips

Jim,

No, you are being accurate. The number can be derived from it, but per se it
is not that number.

Thanks!
 
Top