Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
For Each wks In wbk.Worksheets With wks LastRow = .Range("A" & Rows.count).End(xlUp).Row '-- <<< blows up here 2nd time thru LastCol = .UsedRange.Columns.count End With For intRows = 1 To wks.UsedRange.Rows.count For intCols = 1 To wks.UsedRange.Columns.count Next '-- Col Next '-- row Next '-- wks '-- at the end of each workbook wbk.Close app.Quit Set wks = Nothing Set wbk = Nothing Set app = Nothing
|Need Help,, i m beginner in vba,, i'm writing a code for exporting the data from Userform to Access Database||13||64|
|Controls on a form not HIDING as they should||3||22|
|Question about INSTR - need to extract data MS ACCESS query||6||22|
|Modifying a MSAccess table from another MSAccess DB||8||37|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!