Macro - Conditionally Define a Range

Hello,

I am still quite new to the VBA world. I have a spreadsheet in which on worksheet 2 ("Forms") I have a macro that will draw checkboxes (and link them to the same cell) based on the range you give it. So, for example, I have:

Please Login or Register  to view this content.

The Macro itself works fine when you take the time to define the range. The gaps are for rows that are intentionally left blank (for the sake of organizing) and don't need checkboxes.

So what I am looking to do is to have the macro figure out which rows need checkboxes in columns G-N based on whether or not there is content in column F which has text in (or not if it is a blank row).

Problem is, I have no clue where to start here on changing the the Range section ("For Each myCell In .Range...

Change this:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Does it help?

Ok that didn't really work so I am including the entire code... (i emailed it to myself hence the partial code above)

Please Login or Register  to view this content.

Nevermind, got it with GeneralDisarray's post

THANKS!