select all cells

Good morning, I run a monthly report where I have to pivot table a sheet, except the row numbers are different every month. Is there a way to change the code below so it'll capture all active cells in the sheet before I pivot table it? Here's my code: Sub Macro1() ' ' Macro1 Macro ' '...

Hi! I am new to creating macros and have fumbled my way through creating a macro that works, however, sometimes with a few errors. The first error I am continually experiencing is that if there is more data than I was expecting (over 300 rows) then I receive an error. To deal with this, I have...

Hi, and thanks for taking the time to view this post. I am running the following code to create 20 or thirty message boxes that activate when particular cells are clicked. Essentially, I need to provide the user information related to specific cell entries. My problem is when the user selects...