Just learning VBA; not familiar with msdn instructions for coding errors. Don't know when to apply Dim and Set functions within code to identify objects properly
1a Cannot get Copy & Paste to work because code finds problems in opening statements. I cannot properly write code using a variable "row number identifier" along with a column ID, because the row identifier comes from the "Start" worksheet at 'Start'!C1, while the data being selected is on the "Data" Worksheet at any Row identified in Start!C1 and in "Data" "G" Column.
1b The Paste operation must place the data on the "Start" Sheet at column "N6"
Not sure what you mean in the directions item #4 "CODE tags". So made the question explicit. No need for sample file.
2a Must "Split" Hyperlinked URL's at delimiter"; " (a semicolon with a space) BUT Must start a new line, so I need a CarriageReturn & LineFeed CrLf. I DO NOT want the split to generate columns, as is commonly explained. I NEED a new Row for each URL.
3a I NEED a course on VBA. But after experiencing others teaching how to do a task, I find I might be able to do THAT task, but CANNOT identify how to perform the next logical step. Your teaching technique explains the What and Why of how to perform the tasks. Therefore, it would work better for me. I used to teach and my last job was managing 20+ programmers, but never learned to code. Now retired and in the Philippines, I must learn to code. Please advise your courses? And price.