RE: $$Excel-Macros$$ Help with loop to search and copy data

Hi, I've modified your macro below. The red text is old, to be deleted. The green text is the new bits. I've used For Each / Next to loop through each cell in the UsedRange, and Like rather than Find I can't test it properly without your workbook, so you'll have to do that and let me know

RE: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook

Hi, The attached contains a basic event macro. Change any cell in the range A1:A4 to change the rectangle's size and position. You may be able to adapt it for your own needs. Regards - Dave. Date: Mon, 12 Jul 2010 12:43:39 -0700 Subject: $$Excel-Macros$$ Using Excel to Control Shapes

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Dear Dilip, Can you explain the logic, of getting the Unit Price 25-30, 30-35. as the source date holds no such units. Regards Ahmed Bawazir On Tue, Jul 13, 2010 at 12:59 PM, Dilip Pandey dilipan...@gmail.com wrote: Hey mr. Soni.. Two Charts has been created as per

$$Excel-Macros$$ VBA code for insert data from user form

Hi all, I want to know the code how to insert data entered in user form in excel sheet, *workbook is attached*. I also want to know the easiest code to find the last row or last column. Regards, Deepak -- -- Some

Fwd: $$Excel-Macros$$ VBA code for insert data from user form

Dear Deepak, Please find attached workbook with solution. Warm Regards, Noorain Ansari noorain.ans...@gmail.com -- Forwarded message -- From: Deepak Rawat deepakexce...@gmail.com Date: Tue, Jul 13, 2010 at 4:38 PM Subject: $$Excel-Macros$$ VBA code for insert data from user

Re: $$Excel-Macros$$ VBA code for insert data from user form

Hi Deepak, For last row Cells(1, 1).End(xlDown).Select For last column Cells(1, 1).End(xlToRight).Select ---Irfan On Tue, Jul 13, 2010 at 4:38 PM, Deepak Rawat deepakexce...@gmail.com wrote: Hi all, I want to know the code how to insert data entered in user form in excel sheet, workbook

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Hey Ahmed.. the Honest man.!! :) You are most welcome to share the knowledge and experience(s) and offcourse for a friendship filled with learning - both the sides.. :) -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Hi Ahmed, Those groups has been created by using Group and Show Detail feature of Pivot Table. Just right click on the pivot table and you'll see this option. Get back in case you still have challeng(es) in this regard. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile:

Re: $$Excel-Macros$$ Re: excel tutorial book

* * On Mon, Jul 12, 2010 at 5:48 PM, Nikhil Shah nikhil201...@gmail.com wrote: Hi Rajendra Soni, Wow Great Help for sending Excel URL Nikhil Shah On Mon, Jul 12, 2010 at 10:04 AM, Soni.Rajender soni.rajen...@gmail.comwrote: Hi Please find below the link for MS Excel resources.

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Hey Dileep, I am a CA currently in industry and planning to launch my own consultancy soon, I think macro's can be a good product for me to sell :-) , but for that I need to learn the same :-) can you tell me from where I should start ?? :-) What are the resources etc Profit share assured !!

Re: $$Excel-Macros$$ Re: Urgent - MS Excel charts

Hi Janardan, You can learn macros by simply searching internet for learning materials n ebooks. There are many websites / groups / communities available through which you can enhance your learning. Best of luck for your future plans. Thanks n Regards, DiLipandey On 7/13/10, Rajesh Janardanan

Re: $$Excel-Macros$$ Google Translator Using VBA - HELP !!!

PLease help me on this. On 7/13/10, Anish Shrivastava anish@gmail.com wrote: Hello Experts, Yesterday, while using Google Translator manually I just thought if it can be automated using VBA. Actually what my task includes is to Convert various European language values to Standard

Re: $$Excel-Macros$$ Re: Password recover

On 7/25/09, Upendra Singh upendrasinghsen...@gmail.com wrote: Hi Abdul, Please find enclosed Excel Add-in you can use to unprotect your sheet. Please note if your workbook is protected with password to Open or password to write, this add-in will not help. Regards, Upendra Singh

$$Excel-Macros$$ Vba code to get html propatis,Vba code to get html page detail,Vba code to get internet explorer detail

Hi Friends Today i am gone show you that how to get html Properties by using VBA code and macro. Option Explicit Option Compare Text Const cForm_name As Long = 1 Const cForm_Id As Long = 2 Const cElement_Name As Long = 3 Const cElement_ID As Long = 4 Const cElement_nodeName As Long = 5 Const

Re: $$Excel-Macros$$ Re: Password recover

Hey Buddy, Pls copy the below code and simply run, this will break all excel passwords. Regards Rajender Soni Public Sub AllInternalPasswords() ' Breaks worksheet and workbook structure passwords. Bob McCormick ' probably originator of base code algorithm modified for coverage

$$Excel-Macros$$ Excel vba link

Hi Everyone, Please check this link of excel vba http://www.excel-vba-easy.com/vba-basic-msgbox.html Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :