hung

I have a list of dates with blank cells in between at various spaces. I need to add 7 days to the date above it no matter it's location (not the last value in the column). Is this the most effective formula I can use to do this? Sometimes it seems to get hung up and not calculate. Here's an...

My workbook can have hundreds of worksheets. I have a macro that wil loop thru them , activate each sheet, perform a funtion and then move to the next. At times i can not always tell if it is runnng or hung up. How can i display a warning like "active Work sheet is (Sheet name)" and have it...

Hey everyone. I am currently working on Debugging a code that has worked wonders for me for the last 10 years. Here is my code: 1 Worksheets(1).Select 2 R = Range("A65536").End(xlUp).Row 3 For Each Cell In Range("A2:A" & R) 4 Cell.Hyperlinks(1).Follow...

<tbody> I keep getting this error Unable to get the PivotTables property of the Worksheet class from the code below (I used recording button to have these coding from Excel) I'm not sure what is wrong, but any help would be helpful. It hung up at the "<code>With ....End With"</code> part...