Re: $$Excel-Macros$$ Writing Code for creating pivot table

Hi, 1. It is not necessary to define range, I have define it to avoide using Sheets("2011-10-26").Range("A1") every time in the code. After defining range, instead of Sheets("2011-10-26").Range("A1") i can simply use rng object Try to give complete reference in the code for ex: If you want to ins

Re: $$Excel-Macros$$ Writing Code for creating pivot table

Swapnil, Thanks so much for your help. I could see you have added few codes ** Set ptsheet = Worksheets.Add Set rng = Sheets("2011-10-26").Range("A1") ** 1. Would like to askthat means we have to define the range before creating pivot table? 2. What if i have to create this piv

Re: $$Excel-Macros$$ Writing Code for creating pivot table

Hi, It will be easy to solve issue if you provide sample data. In your code you have not defined DataField, without data field it will show you blank pivot. Share sample data so that group can provide you correct code. Regards, Swapnil. On Wed, Oct 26, 2011 at 10:07 AM, Chan Darwin wrote: >

$$Excel-Macros$$ Writing Code for creating pivot table

Dear all, I wrote the code in creating pivot table for my source of data. However, when run the code, it prompts with the message. "Run-time error '438': Object doesnt support this property or method" Below please find the code also. Sub CreatePivotTable() Dim PTCa

$$Excel-Macros$$ HOW TO REPLY TO A POST

Sirs, Don Guillet did reply to my query re "HELP: SHORTEN MY MACRO USING LOOP". I want to thank him but i don't know how to reply. How i should i reply to him or the group? Thank you. -- -- Some important links for

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

Sorry Sam you are completely , i mean excel 2007 (Excel workbook not support vba) so save ur file in excel 2003 or excel macro enable 2007 format > On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad > wrote: > >> Dear Noorain, >> >> when I am saving your file it shows the attac

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

xlstime, that is the most hilarious statement I have ever seen. You might want to reiterate. Excel 2007 has the macro enabled file and the non-macro file apart from a few other formats. To use VBA, you'll have to save the file as a macro enabled file, and the extension is .xlsm Any file saved in

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

Haseeb, why u use int or mod function ? pleas tell me On Wed, Oct 26, 2011 at 12:35 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Murali; > > You can also use INDEX with INT & MOD > > see the attached > > HTH > Haseeb > > -- > > ---

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

excel 2007 not support VBA coding so save ur in excel 2003 or xlsb On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad wrote: > Dear Noorain, > > when I am saving your file it shows the attached error. please suggest. > > Regards, > > Aamir Shahzad > > On Mon, Oct 24, 2011 at 5:03 PM, MURALI NAGARAJAN

Re: $$Excel-Macros$$ Sequentially numbered pictures in Excel 2003

To attach a file, go to your google mail, and check for this message, and while doing a reply, you can attach a file as you would normally. Sam On Tue, Oct 25, 2011 at 5:18 PM, Don wrote: > How would I do that? I do not see a way to attach it to this post and > unfortunately it is not on a web

Re: $$Excel-Macros$$ Removing specific characters from strings of texts

Hello Zeunasc, You can also do it through Find/Replace command. Select the column, press Ctrl+H to bring Find/Replace command. Find What : *(hitcnt** Replace All with blank. Again; Find What : *0x** Replace All with blank. Note: There is a * after each Find item. HTH Haseeb -- --

Re: $$Excel-Macros$$ Need to Format Date By Formula

chg c2 to this =VALUE(TEXT((LEFT(A2,11)),"MM/DD/")) or =VALUE(LEFT(A2,11)) Don Guillett SalesAid Software dguille...@gmail.com From: John A. Smith Sent: Tuesday, October 25, 2011 10:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need to Format Date By Formula Excel Teach

Re: $$Excel-Macros$$ Being informed when a user changes sheet

Chris, first can you explain what you want to achieve with the sheet change event. We can then decide on what kind of event and the level of the event required. For example, if you just want to know whether the users switched from your workbook to another workbook, you don't need a sheet event, but

$$Excel-Macros$$ Being informed when a user changes sheet

My macro needs to know when the user changes sheet. I have located the Workbook_SheetActivate event but I'm confused as where I place this. If I place it in a code module in my macro it does not get executed. If I place it in ThisWorkBook of my macro it does get executed when I change s

Re: $$Excel-Macros$$ unable to do any operation with this data

With a bit modification to Noorain's formula, you can make it a little more smaller *=--SUBSTITUTE(A2,CHAR(160),"")* Regards, Sam Mathai Chacko On Tue, Oct 25, 2011 at 7:32 PM, dguillett1 wrote: > I have this in my personal.xls file assigned to a custom button > Select your range and fire i

Re: $$Excel-Macros$$ Need to Format Date By Formula

Excellent! Thank you for your quick response and your continued teachings. John On Tue, Oct 25, 2011 at 11:56 AM, Sam Mathai Chacko wrote: > =DATEVALUE(TEXT((LEFT(A2,11)),"MM/DD/")) > > OR > > =DATEVALUE(LEFT(TRIM(A2),10)) > > rEGARDS, > > Sam Mathai Chacko > > On Tue, Oct 25, 2011 at 9:22

Re: $$Excel-Macros$$ Need to Format Date By Formula

=DATEVALUE(TEXT((LEFT(A2,11)),"MM/DD/")) OR =DATEVALUE(LEFT(TRIM(A2),10)) rEGARDS, Sam Mathai Chacko On Tue, Oct 25, 2011 at 9:22 PM, John A. Smith wrote: > Excel Teachers, I need to format 09/14/2011 0938 into 9/14/11 (or a real > date format). Please see attached spreadsheet. > > Thank

$$Excel-Macros$$ Need to Format Date By Formula

Excel Teachers, I need to format 09/14/2011 0938 into 9/14/11 (or a real date format). Please see attached spreadsheet. Thank you for your help. John -- -- Some important links for excel users: 1. Follow us on TWIT

Re: $$Excel-Macros$$ Selecting contents of a control

Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) Me.TextBox1.SelStart = 0 Me.TextBox1.SelLength = Len(Me.TextBox1.Text) End Sub On Tue, Oct 25, 2011 at 8:00 PM, Chris Boxall wrote: > I should like to be able to select

Re: $$Excel-Macros$$ HELP: SHORTEN MY MACRO USING LOOP

Perhaps you can attach a file(s) 1. can be solved with a loop where the file names are listed in a2:a22 Cash Disbursement Schedule.xls" etc sub openfilesinlist() mymonth="OCTOBER" 'or an inputbox asking for the month or in a cell... for each myfile in range("a2:a22") Workbooks.Open Filename:

$$Excel-Macros$$ Selecting contents of a control

I should like to be able to select the contents of a TEXT BOX control on a Form. I have moved the focus to the TEXT BOX using the .SETFOCUS method. The box shows the insertion point at the end of any text in the field. However, it would be nice to automatically select (from a VBA macro) the whole

Re: $$Excel-Macros$$ unable to do any operation with this data

I have this in my personal.xls file assigned to a custom button Select your range and fire it Sub fixmynums() Application.ScreenUpdating = False On Error Resume Next For Each C In Selection If Trim(Len(C)) > 0 And C.HasFormula = False Then C.NumberFormat = "General" C.Value = CDbl(

Re: $$Excel-Macros$$ Sequentially numbered pictures in Excel 2003

How would I do that? I do not see a way to attach it to this post and unfortunately it is not on a web-server only an internal secured data server. Don On Oct 25, 2:30 am, NOORAIN ANSARI wrote: > Dear Don, > > can you share your workbook with Group. > > > > > > On Tue, Oct 25, 2011 at 1:40 AM,

Re: $$Excel-Macros$$ unable to do any operation with this data

Dear Sanjib, Replaces each nonbreaking space character (Unicode value of 160) with a space character (ASCII value of 32) by using the SUBSTITUTE function, and then removes the leading and multiple embedded spaces from the string " BD 122" (BD 112) -- Thanks & regards, Noorain Ansari *http://e

Re: $$Excel-Macros$$ unable to do any operation with this data

Dear Sanjeet, Please try below formula and see attached sheet. =TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On

Re: $$Excel-Macros$$ unable to do any operation with this data

Dear Swapnil Palande, how to remove the space. What function do i use? PLease help ragards, sanjib On Tue, Oct 25, 2011 at 1:36 PM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > Hi, > > There are white spaces before number, remove those spaces and then you can > use functions. > >

Re: $$Excel-Macros$$ unable to do any operation with this data

Hi, There are white spaces before number, remove those spaces and then you can use functions. Regards, Swapnil. On Tue, Oct 25, 2011 at 1:30 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Members, > > Please see the attachment. I am unable to do any operation with this >

$$Excel-Macros$$ unable to do any operation with this data

Dear Members, Please see the attachment. I am unable to do any operation with this figure in the excel file. (i.e. Addition, multiplication, division etc) please help regards, Sanjib -- -- Some importan