Dear Solution Provider,
I have one excel work book in which I have written a VBA program for copying the Data from On sheet to another , But I want to change the sign of a number from Minus to plus Example : -1234 so iwant the figure of 1234.
For you ready reference I have attached the file also.
Vajeed
Use VBA's Abs function.
If posting code please use code tags, see here.
Hi,
Try
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Or
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thanks a lot its working , Very Good Answer
Im Sorry gto disturb you again, What is D stand for.. in your Code................ and let me know if I have three rows in the details sheet how to do.Vajeed
in Actual Excel Sheet No d column will be there attached is just for your information.
Can you please tell me how to use,
Please tell me the below details.
1 ) What if I have en number of rows and columns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks