$$Excel-Macros$$ Lock VBA project for multiple files

Hi, Is it possible to lock VBA project of all xls and xlsx files of a folder and its sub folders. Thanks Hiren This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mi

$$Excel-Macros$$ Run time error '13'... Type mismatch error

Hi I am getting following error while running below mention code. Please help. [cid:image001.png@01CC2B7B.1B6C0EA0] Dim nrow As Long ActiveCell.Select Cells(8, 1).Select ActiveCell.Offset(1, 0).Range("A1").Select Range(Selection, Selection.End(xlDown)).Select nrow = Range(Selection, Selecti

$$Excel-Macros$$ Macro to highlight matching numbers

matching so I have to highlight those rows and so on These process I have to do it for more than 15000 lines. Please help Thanks Hiren Sheth This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privile

RE: $$Excel-Macros$$ how to know the content of a text box of user form

nt in the Text Box. Textbox1.value is the answer of your question. :) Hope this example will help you. Regards, Deepak On Thu, Nov 11, 2010 at 8:52 PM, Hiren Sheth mailto:hiren.sh...@viteos.com>> wrote: Hi, Please let me know how to obtain the content of a text box of user form? Thanks Hiren

$$Excel-Macros$$ how to know the content of a text box of user form

Hi, Please let me know how to obtain the content of a text box of user form? Thanks Hiren This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mis-transmission. If you

RE: $$Excel-Macros$$ How to consolidate the data using macro

macro try attached file see if it helps . On Thu, Oct 28, 2010 at 3:46 PM, Hiren Sheth mailto:hiren.sh...@viteos.com>> wrote: Hi Excel Gurus, I would like to prepare the consolidated file on daily basis using macro. I am using excel 2010. My team is working daily on some excel files(

RE: $$Excel-Macros$$ How to consolidate the data using macro

Hi Excel Gurus, I would like to prepare the consolidated file on daily basis using macro. I am using excel 2010. My team is working daily on some excel files(around 25-50 files). All excel files are save in a particular folder on daily basis with name containing the date stamp. I would like to

$$Excel-Macros$$ Help require to understand the Formula of the attached sheet

Hi Experts, Can you please explain formula of cell B17, B18, B19 and B20 of the attached sheet. Thanks Hiren This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mis-

RE: $$Excel-Macros$$ Problem New1

Define ltext as string instead of long. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of hemant shah Sent: Thursday, August 19, 2010 10:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Problem New1 Hi Team, I nee

$$Excel-Macros$$ Is it possible that a sub procedure will do certain steps and at the end it will delete itself

Hi, Is it possible that a sub procedure will do certain steps and at the end it will delete itself. Seems to be a strange question but is it possible? Regards Hiren This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No c

RE: $$Excel-Macros$$ Send Email from Excel to Multiple Addresses

Hi, I have just started VB programming. I have gone through your query & I think if you change the code to .To = Sheets("Email").Range("A2").Value then mail will be sent to e-mail ID mention in cell A2. I do not know how to send mail if you have more than one emial addrees. But I think this may

RE: $$Excel-Macros$$ Re: Excel check list

ht direction, Rolf Jaeger SoarentComputing http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm On Nov 20, 3:00 am, Hiren Sheth wrote: > Hi Excel Gurus, > > Thanks a lot for sharing your knowledge and solving queries. > > I am planning to prepare a check list for my team mem

$$Excel-Macros$$ Excel check list

Hi Excel Gurus, Thanks a lot for sharing your knowledge and solving queries. I am planning to prepare a check list for my team member for a particular task. I mean once they finish the working on the excel sheet and try to close that, a pop up of check list will appear which state the steps to

$$Excel-Macros$$ Re: pdf to xlsx

Hi Mahesh, >From where I can get the below mention software? Regards Hiren From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Prashanth Banneni Sent: Friday, September 18, 2009 2:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: pdf to xl