I have a Macro built in excel and at the end of the macro, I want it to move the selected cell down one row.
For example, the macro performs its function, then I need it to move down one row to set itself for performing the macro again. I tried using the down arrow key in the macro recorder and that did not work.
Thanks
[OTP] VBA - Excel Macro question
Chrismanster
If your using the VB within Excel then this is VBA (Visual Basic for Applications) which the macro record is generating code for then this is a very different product from VB.NET and there are some other locations where you will get a quicker and better response to your VBA questions.
You may find more assistance in following which specifically deals with MS Office development.
Office Automation: office.developer.automation newsgroup
http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US
Or the Office Newgroups
http://www.microsoft.com/office/community/en-us/default.mspx d=1
Or the VBA Forum
http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=74&SiteID=1
Hope that helps....