Hi, I have very little idea of how to program in VBA but I've managed so far by consulting internet forums to obtain the following code to do what I need, but I am getting an error and I don't know what is wrong? Here is the code:
Please Login or Register to view this content.
Last edited by VBAn00b; 12-01-2010 at 02:29 PM.
What is the code supposed to do? I don't see what the variables are for.
Everyone who confuses correlation and causation ends up dead.
Like so:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Well, at the beginning I kept getting Run-time error: '1004': Application-defined or object-defined error. So I thought it was because of undefined variables..
But when I tried your code, it gave me the error code '1004' again..
I didn't bother to check your formulas, I just assumed you recorded a macro to get those. My bad.
Please Login or Register to view this content.
Ahhh yes, it works now.. thank you so much!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks