adding column to workbook with macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 06 Nov 2007 15:53 GMT

If I add a column to an existing workbook/sheets...do I have to recreate
existing macros in that workbook..or will they 'auto-adjust' to the new
column inserted ?

The existing macros work on various columns with different functions

Thanks, Tim

Reply to this Message

Gary''s Student - 06 Nov 2007 16:16 GMT

Say C1 contains "hello"

running:

Sub test()
MsgBox (Range("C1").Value)
End Sub

will echo that contents

If you add a column at the beginning of the worksheet, the macro will not
adjust.

Running the macro will no longer greet you. (But there is a way around this)

Signature

Gary''s Student - gsnu2007a

> If I add a column to an existing workbook/sheets...do I have to recreate
> existing macros in that workbook..or will they 'auto-adjust' to the new
[quoted text clipped - 3 lines]
>
> Thanks, Tim

Reply to this Message

Earl Kiosterud - 07 Nov 2007 03:11 GMT

Tim,

Macro cell references don't adjust as do formula cell references. You can use range names
in your macros instead of hard cell references. The references for those names will adjust.
Insert - Name - Define (or just type a name into the name box).

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> If I add a column to an existing workbook/sheets...do I have to recreate existing macros
> in that workbook..or will they 'auto-adjust' to the new column inserted ?
>
> The existing macros work on various columns with different functions
>
> Thanks, Tim

Reply to this Message

Rate this thread: