I still recommend a specified (or named) range rather than hard coding the column number, and (with the latest code) relying on "end-up."

For your last question you need to be more explicit. Do you understand what scope means? Think of it as either a specified range, selection, procedure, module, or project. Consider this: have you noticed that you can't have consecutive statements that say
dim i as integer
but you can have two within a module?

With that in mind, does the duplicate declaration make sense? If not, just list all your code and indicate what is highlighted when you get the compile error.

Jumping ahead, you're probably going to want
for each sheet in sheets (or worksheets)
wrapped around your single sheet code. Does that approach fit your workbook?