Hi, I am trying to create a function that I can use on any cell in my workbook. I want it to essentially copy the cell and paste special the value back into the same cell. I am trying to do so with the following code but its not working:
Any help would be appreciated, thanks!
Please Login or Register to view this content.
Last edited by ashriva1; 08-19-2021 at 11:27 AM.
Hi,
How about this?
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Oh yeah that's much simpler, thank you!
Actually I realized I worded my question kind of incorrectly. I want to create a converter function that I can use in some cells.
For example cell A3 = ConverterFunction(A1+A2)
This would leave me just the value of the formula instead of the formula in the cell itself. When I tried using this function with the ActiveCell property it just gives me a value error.
OK, that's a little more difficult. A customer function (UDF) works the same as any other function - it will stay present in the cell until you write over it as we've discussed above.
If you need just values in specific cells you could maybe use a worksheet_change event to drive a macro to do this for you. Are there specific cells that need this treatment?
The cells that need this function will change each month, and I don't want to my entire workbook to change into values because I still need formulas for other functions.
Sub Maybe
Or you can use Union for non adjacent cellsPlease Login or Register to view this content.
Change cell references as required.
Please Login or Register to view this content.
Last edited by jolivanes; 08-19-2021 at 05:45 PM.
The previous "With_Union" suggestion does not work.
Change the Ranges as required.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks