Hi. I posted this a little while ago with no luck. Any new takers??
I need a macro for inserting a column at a prescribed location (i.e. this will vary according to what the user wants). This column needs to have the same formulas as the column to the left. I would like a dialogue box to come up asking (1) at what location would you like the column inserted; and (2) How many columns would you like to insert.
To prevent columns being inserted at locations in the worksheet where they shouldn't be, if possible, I need some error checks in the macro. i.e. if "Cell to Left of insert location"="Name" don't allow a column to be inserted and return error message "Column could not be inserted".
Hope this makes sense.
Cheers
I need a macro for inserting a column at a prescribed location (i.e. this will vary according to what the user wants). This column needs to have the same formulas as the column to the left. I would like a dialogue box to come up asking (1) at what location would you like the column inserted; and (2) How many columns would you like to insert.
To prevent columns being inserted at locations in the worksheet where they shouldn't be, if possible, I need some error checks in the macro. i.e. if "Cell to Left of insert location"="Name" don't allow a column to be inserted and return error message "Column could not be inserted".
Hope this makes sense.
Cheers
