Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA newbie needs help
be cause it has an f at the start of CopyAHTs? there are afew in the workbook but the one before is this: Sub sCopyout() 'Filters out unnecessary intervals and copies data for input in to the DB Dim lngRow As Long Application.ScreenUpdating = False Output.Range("$A$1:$L$100000").AutoFilter...- SLW89
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA newbie needs help
Hi, im fairly new to VBA and need help breaking down this code my predecessor created: Sub fCopyAHTs() 'Copies the AHTs created to the Daily Tab for reference Dim lngRow As Long, lngPasteRow As Long Dim lngCol As Long, lngPasteCol As Long Dim lngLoop As Long, lngColLoop As Long Dim lngRowCol As...- SLW89
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
