You haven't Set the wb object or was that done in another procedure? Where are those Dim statements located - not in the procedure you posted.
Should add Option Explicit to the top of all modules.
You haven't Set the wb object or was that done in another procedure? Where are those Dim statements located - not in the procedure you posted.
Should add Option Explicit to the top of all modules.
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.