Recent content by IfThenElvis

Is the sheet protected? Click on Tools-Protection-Unprotect Sheet.

Note: This question is also posted with replies in the Microsoft Office Forum.

I tried moving the macros from a Module1 to the Workbook module to a Worksheet module & it still worked. Try removing "Deleting" from the PasteSpecialXX macro and then run each macro separately. Which one bombs out? I'm using Excel 2000. Is your sheet protected? Do you have any Event...

Hi Arthur, you can't call your Procedure 'Sub PasteSpecial' as it is already defined as an Excel operation, call it "PasteSpecialXX' or something else. You may also have to rename Public Name As String. When I make these changes it runs OK for me. Doug

If you are looking for an automated way to delete rows then try this (modify as required. It's best when deleting rows via VBA to work up from the bottom: Sub del_rows() lastrow = Cells(65536, 1).End(xlUp).Row For c = lastrow To 1 Step -1 If Cells(c, 1).Value = "aa" Then Cells(c...

Hi, try this: =IF(rounddown(B3,0)>A3),"late","on time") Excel days are saved as whole numbers and hours/minutes as fractions. Today May 30 is 37771 and 12 noon would be 37771.5 So you can rounddown the delivery time to remove the time of day.

A quick & dirty way would be to put this formula in D4 and copy it down column D. Blanks would show up on non-subtotal rows. =IF(RIGHT(B4,5)="total",COUNTIF(B:B,LEFT(B4,LEN(B4)-6)),"") Hope this helps.