Thank you, Macropod for the tips. I just want to make sure my instincts are correct:
Quote:
Originally Posted by macropod
For example:
...
StrWkBkNm = "C:\Users" & Environ("Username") & "\Documents\WordList.xlsx"
StrWkSht = "Sheet1"
|
[I assume, enter my own local path to the .xlsx between the " ". And also, if the workbook I'm using has a sheet called "Table1 (2)" with the word list, I should swap out for "Sheet1"]]
...
Quote:
Originally Posted by macropod
' Find the last-used row in column A.
iDataRow = .Cells(.Rows.Count, 1).End(-4162).Row ' -4162 = xlUp
|
[My column is entitled "Column1" so I assume I should change out "column A".]
I'll try this code next. Thank you again!
--David
09-27-2022, 12:19 PM
Similar Threads
Wildcards: searching for multiple words / expressions close to each other
Windows 10 
Office 2021
Threaded Mode