Hello All,

I have a very simple macro that takes data, does a simple pivot and then copy's and pastes the data as values to another sheet. I have tons of macro's that do the same thing. However, I decided to get fancy and put a command button that would let users kick off the macro at the click of a button.

However, after I did this the macro now crashes whenever I use the command "Cells.Select". This needs to be done in order to copy the pivot page and paste the values on another sheet.

The error that I get is: Select Method of Range class failed

I have used this command a hundred times without issue, so not sure what is going on now. This all started when I put in a command button. Does anyone know why this would happen and the workaround for it?

I appreciate any help that can be provided.

Kelly