Hi, I am new to this group.
I am not a VB coder. I have recored a macro, but when I am executing I am getting 1004 run time error.
Getting error at this line.
Total code is below.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by arlu1201; 08-14-2012 at 04:25 AM.
The problem is the formula, not the code.
Change Excel to R1C1 mode, then run this:
The formula will print in the Immediate window. Copy it and try to put it in a cell. Fix the formula so it works when you enter it from the UI, then fix the code.Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
sandhyasrik,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks