LinkBack URL
About LinkBacks
Ok, I have a question, is there a way to copy the data of a field and not the formula over in VBA?
Ok, I have a question, is there a way to copy the data of a field and not the formula over in VBA?
Yes, there is a way. You can either copy the cell / range and do paste special values or directly point the destination cell to the source cell.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Cyberpawz,
Can you attach an example spreadsheet, so I could attempt to give the best solution.
Thanks,
Bonny Tycoon
Cyberpawz,
Here is a simple example, you can improve the code for your use:
Please Login or Register to view this content.
Sure. Here is the basis of what I need.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks