Delete a Column when in a Macro-Worksheet Event?

J

jeannie v

Good Morning, Experts:

I have a workbook with Macros and one of the worksheets is data that I have
copy/pasted from another application. This application has a hidden column,
but pops that hidden column when I copy/paste it to the Macro'd Workbook. I
want to delete that Column "C" before I run my RunAll Macro for the entire
workbook. Is this a worksheet event and if so, what would the View Code
look like (I'm really new at View Codes)?

Can anyone help me?
 
P

Peo Sjoblom

Put it in the runallmacro before the rest of the code runs

Columns("C:C").Delete

'rest of the code
 
J

jeannie v

Peo: Thank you for lending your expertise.....it worked perfectly. I guess
I was making it more difficult than it had to be...
 
Top