-
Rather than EndNow after the MsgBox, I should have put:
[vba]GoTo EndNow[/vba] Using End Sub skips the routine that resets some things.
As we said, activecell is not the route to pursue. When you say last row, I don't know what that means. Last row with data based on a column of data or any column with data or the literal last row 104576?
Most go to the end of the data in column A or the row that follows that. The commented line goes to the next row after last row with data in column A. e.g.
[vba]
Sub Test_Updates()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Select
Range("A" & Rows.Count).End(xlUp).Select 'last row in column A with data
'Range("A" & Rows.Count).End (xlUp).offset(1).select 'after last row in column A with data
Updates
Next ws
End Sub[/vba]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules