Searche Range and Change It
Hi All
Im Looking for a VBA code that will do following:
Search range C4:V83 for "Chopped" value (there will be a few cells with that value in that range)
For each one of that cells coppy and paste special as value only on top of the same cell (I just want to delete the formula that was there before to make it a permament record)
Thaks in advance for all your help
Give this a try:
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!)
Re: Searche Range and Change It
Hi,
Please find the attached solution of the same. Hope this will solve your query.
Regards,
Deepak Rai
It works superb! Just one more thing i completely forgot to mention.
Im pressing the button on a different page and I would like the code to refer to
"Cut Record" sheet rather than the sheet im on at the moment of pressing a button
Many thanks
Like so, just edit the sheet name as needed in the macro:
Please Login or Register to view this content.
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