Okay, this one is driving me crazy. I have a macro that creates a pivot table, then copies it to another spreadsheet by doing a "Paste Special - Values", followed by a "Paste Special-Formats". My problem is that column A contains text values instead of numbers, and blanks which I want to fill in. When I select that column and use the routine Edit>Go To>Special>Blanks, then hit the " = "sign, then up arrow, then ctrl-shift-enter, the blanks fill in on only to the next text number, not all the way down the column. I know the problem there is that the numbers need to be numbers, but I don't know how to programmatically do that.
If I first select the column and multiply it by 1, the blanks are replaced with zeros, and again my routine won't work to fill in the blanks, 'cause they're no longer blank.
If I insert a column and use a formula such as
and then copy that column and paste the values back into column B, it looks like everything is right, except I still need to fill in the blanks. However, going to Edit>GoTo>Special>Blanks tells me there are no blanks.
I've attached my spreadsheet so you can see what data I'm working with. I realize this must be simple, but it's simply beyond me right now. Thanks in advance for any help I can get on this.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks