Forum Discussion

judithdapon's avatar
judithdapon
Copper Contributor
Jun 27, 2023

Invalid or false argument

The macro that I am trying to use on my file is getting an invalid or false argument error. 

I recorded on how I pivot the file I am working on using Macro. I used the same sheet I used during the recording to test it if I will get an error when I run the macro. However, I get the invalid or false argument error. This was the error I am getting.

 

 

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jun 28, 2023
    If you already ran this on a file then you will get errors because that range already has data and that TableName already exists. You probably want to edit that macro and remove the TableName setting (should auto name it) and TableDestination will either be removed or changed to automatically assign a new location. But as for why you are getting an error, I suspect that is the reason why.

Resources