Weezer
09-28-2010, 01:59 PM
Hello everyone,
I have a piece of VBA script that I compiled & it works. I have a function in another worksheet that works perfectly fine too. My problem is either within the function or after it I'm trying to call the Macro that I compiled in another Worksheet to Activate. The reason I'm doing this is because the function runs by a button, so if I put it within the function it will automatically call the Macro and do the function in the other worksheet. I am trying to automate the whole process hence I'm doing this.
I'm not sure if anyone would suggest a sub-routine, but I don't know how to go about that. If anyone could help me out I would really appreciate.
Thanks
I have a piece of VBA script that I compiled & it works. I have a function in another worksheet that works perfectly fine too. My problem is either within the function or after it I'm trying to call the Macro that I compiled in another Worksheet to Activate. The reason I'm doing this is because the function runs by a button, so if I put it within the function it will automatically call the Macro and do the function in the other worksheet. I am trying to automate the whole process hence I'm doing this.
I'm not sure if anyone would suggest a sub-routine, but I don't know how to go about that. If anyone could help me out I would really appreciate.
Thanks