Delete a Column when in a Macro-Worksheet Event?
 

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?
--
jeannie v

Delete a Column when in a Macro-Worksheet Event?
 

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

Columns("C:C").Delete

'rest of the code




--
Regards,

Peo Sjoblom


"jeannie v" wrote in message
...
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?
--
jeannie v

Delete a Column when in a Macro-Worksheet Event?
 

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


"Peo Sjoblom" wrote:

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

Columns("C:C").Delete

'rest of the code




--
Regards,

Peo Sjoblom


"jeannie v" wrote in message
...
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?
--
jeannie v