Hi guys,
Just wondering how can i insert this formula to my code in VBA:
Excel fromula:
to this VBA Formula:Please Login or Register to view this content.
Please Login or Register to view this content.
Hi guys,
Just wondering how can i insert this formula to my code in VBA:
Excel fromula:
to this VBA Formula:Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Formula:Please Login or Register to view this content.
The code for IF looks something like this in VBA:
Please Login or Register to view this content.
To get values:
Please Login or Register to view this content.
Regards, TMS
Thanks guys for the help. Woprked fine but this is the correct formula i should paste
Please Login or Register to view this content.
Sorry i pasted the incorrect formula:
this one is incorrect:This is the correct formula that i should be inserting in the cdoe below:Please Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
I explained in my previous post how to get the formula in VBA
Please Login or Register to view this content.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks