$$Excel-Macros$$ Question

Hi all friends Please sent me any excel file which is define the macro. i can't understand the macro in excel and i always think that what its use in excel. Thanking U Have nice Day!!! Sudhir Kumar --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: need macro for a simple vlookup and pivot

Hello Hemanth, Recorded macro many fix certain things so i do not want to do that, I want the engine to be volatile.. For example, For example if any new name gets included and where i have to exclude those or in other case name Z is not available in next report for which it thorough error.

$$Excel-Macros$$ Help Me

Hi friends Please find the attachement and help me. Thanking U --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

$$Excel-Macros$$ Re: How do I create a drop down list to select which macro to run

It doesn't matter which module you put a macro in. You can have 10 macros in a single module or 10 macros in 10 modules. You can even name the modules things like Mod_Save, Mod_Open, etc. Excel knows where they are. that also means that you can't use the same sub name in a different module (you

$$Excel-Macros$$ Re: Question

Thanks Amitabh I think it is better to understand macro. On 11/3/09, Amitabh Bose amitabhbo...@hotmail.com wrote: Hi Sudhir, I found the following document via google (searched for: Introduction to Excel Macros) Link:

$$Excel-Macros$$ Helprequire to unprotect word doc .

Dear All, I forget my word document 2007 password. Can any body any idea or code that help us in removing the password so that i can edit my documents. Please assist ? Please help us on following id: aligah...@gmail.com Rgds, Aligahk06 --~--~-~--~~~---~--~~

$$Excel-Macros$$ Segregate data in appropriate sheet with Name as sheet name

Hi Team, Is there a way we can segregate the data depending upon the name (column A) to different tabs. Example If it is a macro, and if I run it, the result would be: Sheet names: “Ramesh”, Ravi”, “Rakesh”, and “Sridhar” and each tab would contain the data as per the sheet name. I hope this

$$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name as sheet name

Hi Team, Is there a way we can segregate the data depending upon the name (column A) to different tabs. Example If it is a macro, and if I run it, the result would be: Sheet names: “Ramesh”, Ravi”, “Rakesh”, and “Sridhar” and each tab would contain the data as per the sheet name. I

$$Excel-Macros$$ VBA code to select non continguous ranges based on column and row number of areas to select

So I already know the row and column numbers row1 = 4 row2 = 8 row3 = 11 column1 = 2 column2 = 4 So now I want to write VBA code based upon the row and column numbers available that corresponds with the selection Range(B4,B8:B11,D4,D8:D11).Select I have been trying to get this to work for a

$$Excel-Macros$$ Re: Helprequire to unprotect word doc .

can u plz attached that file so i try to break the password On Tue, Nov 3, 2009 at 6:19 PM, Aligahk06 aligah...@gmail.com wrote: Dear All, I forget my word document 2007 password. Can any body any idea or code that help us in removing the password so that i can edit my documents. Please

$$Excel-Macros$$ Re: VBA code to select non continguous ranges based on column and row number of areas to select

Is there a way for me to attach an excel file to my posting, I can't see an possibility to attach files? On Nov 3, 2:47 pm, kruijsdijk kruijsd...@gmail.com wrote: So I already know the row and column numbers row1 = 4 row2 = 8 row3 = 11 column1 = 2 column2 = 4 So now I want to write VBA

$$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name as sheet name

Hi I think you are saying you have many columns with headings ramesh, ravi etc and you want a macro which will create as many sheets as the number of columns you have with the respective names and segregates the data in the columns to respective sheets right? It is possible. But why do you

$$Excel-Macros$$ Selecting form text/data in MS Access 2003 using VBA

Hi, I know that this group does not support MS Access 2003, but hope at least some of over 6000 members would help. I would like to know how would I retrieve the text/data from the current form record such as TaskID, without using the setFocus property. I need the form data to update the data

$$Excel-Macros$$ VB Code to track changes without sharing

I have a file with one protected (with password) sheet name Attendance Record. I would like to be able to track changes made by users without sharing the file. Sharing the file disables some functions that I need. The following two macros are already in the file: Sub NoOddRows()

$$Excel-Macros$$ Want to understand OFFSET function.

Hi Friends, I want to understand OFFSET Function and how can i use it instead of vlookup. -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1.