Invalid or false argument

Copper Contributor

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.




1 Reply
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.