LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 127
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Event macro that targets specific worksheet retseort Excel Discussion (Misc queries) 3 February 20th 06 02:47 PM
macro to copy and edit then delete a worksheet lschuh Excel Discussion (Misc queries) 13 July 27th 05 09:02 PM
How to Track Column Insert/Delete Event in Excel mac_excel New Users to Excel 3 July 8th 05 12:11 AM
Chart, Series delete event sino Charts and Charting in Excel 1 March 29th 05 01:31 AM
How do I 'catch' a 'delete cells' event Eric Excel Discussion (Misc queries) 2 March 9th 05 07:22 PM


All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"