Removing a Reference from a cell

[Joeg101]

Hello,

First I would like to disclose that I have limited experience with regards to Macros.

My situation is that I need to export a file into a PDFfill sheet program. Unfortunately, it will not recognize a cell that references another cell. Is there a way or macro that will remove the reference and state the information as though it was manually inputted?

EXAMPLE:

A1= 20
B1= "A1"

After applying the function or macro:

A1= 20
B1= 20

As always, thank you in advance for you time. This Forum has been an incredible resource for me and I have recommended it to a lot of friends. All of them have responded with enthusiastically positive comments about this site.

Regards,

Joe

PS- If this post should be in another forum, please let me know and I will post it in the appropriate forum.

[VBA Noob]

You could make a copy of the sheet and then delete when finished.

Or is it really only one cell that has a formula

Here a example of some code which would make a copy for sheets list. Make a copy. Then do something else with the sheet... bit that is missing then delete the sheet

Please Login or Register  to view this content.

VBA Noob