Application screenupdating does not work

Found Files(i)) Next i End If End With Range("A2: J1500"). I have several report templates (spreadsheets) in one workbook. Display Alerts=False does not work, in other words excessive worksheets are not being deleted. This is the procedure: Public Sub Remove Extra Sheets(By Ref s As String) Dim e Item As Excel. Screen Updating = True end sub Hi Rotimi, Thanks for the code, been trying it out and have a couple of problems..... Formula R1C1 = "=IF(RC[-16]=""found work"","""", RC[-16])" Range("AA1"). Formula R1C1 = "=IF(RC[-16]=""found work"","" "", RC[-16])" Range("AA1"). Auto Fill Destination:=Range("AA1: AA3000"), Type:=xl Fill Default Range("AA1: AA3000"). Once exported I return to the source sheet ("Register") and the row that had the data that I wanted exported has exported the info but the row just sits where it was and appears to only 'clear the contents'.

it cuts the data to destination sheet, goes back to source sheet and the rows have moved up accordingly - I do realise that the action taken is a row removal i.e. Formula R1C1 = "=IF(RC[-16]=""found work"","""", RC[-16])" Range("AA1"). Formula R1C1 = "=IF(RC[-16]=""found work"","" "", RC[-16])" Range("AA1"). Auto Fill Destination:=Range("AA1: AA3000"), Type:=xl Fill Default Range("AA1: AA3000"). As a novice VBA user I take great benefit from this forum. Most of my codes are derived from the responses posted here. Found Files(i)) Next i End If End With Range("A2: J1000"). Sorry for any inconvenience, I don't want to upset anyone with my untimely tardiness (circumstances beyond control and all that) as this forum provides me with vast knowledge to keep the Boss off my back. Akinrotimi, the example you gave me errored out at the range select (1Mill) point and as I had now redone my workbook, there was no need to figure out why yours errored there - hope you understand.

Search for application screenupdating does not work:

application screenupdating does not work-19

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “application screenupdating does not work”