Re: $$Excel-Macros$$ Excel macro delete columns - starting row 23

2010-08-13 Thread dii jii
Attached sample data... Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/gro

Re: $$Excel-Macros$$ Excel macro delete columns - starting row 23

2010-08-12 Thread dii jii
thanks... Here is the details: Geniri ID Year Cutoff Lot info I23 I23 199123 I24 I24 199944 I25 I25 200133 I26 I26 200411 I27 I27 2006

$$Excel-Macros$$ Excel macro delete columns - starting row 23

2010-08-11 Thread dii jii
Hi, Would like to get a piece of code ( excel macro) to delete Columns starting row 23.. This is where my headers start. I don't want include the entire column, i ahve some data above row 23. Thanks in advance. Jimmy -- ---

$$Excel-Macros$$ Excel Macro delete certail column's

2010-07-31 Thread dii jii
Hi, I have a macro that does some kind of comp..task. Now I would like add a piece of code that deletes certain column's before the maco creates the final worksheet.. Ex. Delete Column B,C,M,AA etc. ( My headrs always start row 23).. We tried this way..But cannot connect the existing code... She

$$Excel-Macros$$ Outlook error

2010-07-30 Thread dii jii
Please see if you can resolve the below code..It use to run perfect, but now fails the last statement: Sub patron_RetrieveData() Dim ns As Outlook.NameSpace Dim fld As Outlook.MAPIFolder Dim itm As Object Dim msg As Outlook.MailItem Dim ex As Excel.Application Dim filePreMD

$$Excel-Macros$$ Excel macro - extract subjectline from outlook

2010-07-28 Thread dii jii
Hi experts, We have macro to extract the subject line from outlook mail folders.. It used to work ok..But for some reason now it errors out on this line: *Set ns = Application.Session* iGrandRow = 2 Set wsCsd = wb.Worksheets(Tabnum1) And here is the error messege: “Object doesn’t

$$Excel-Macros$$ Excel Macro update

2010-07-27 Thread dii jii
Hi, We are looking some help about updating our excel macro old report..The changes are mainly merging column (data input) and changing pivot selection. Any help on this would be really appreciated.. Thanks -- -- So