Selecting only visible cells

Hello, I have a sheet and column A has about 64000 cells with values.

When I sort, I need to develop a code that adds a 'checkbox' but only on the items visible to the user. I have created/mashed some code together that does this; however, it appears it wants to start @ A1 and go through the entire list. The result is the items that are visible & have nothing in the cell located in columns C, get a cell while the others do not. The problem is that it's taking a long time to do this and I figure there has to be a means to only work with the visible cells...not all. There just be a way.

My question is what or how to I set the 'lastrow' only to see the visible cells? If there are recommendations please share.

Thanks....b

Please Login or Register  to view this content.

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi,

Your code for getting the last row of a column has an error in it.

Your code:

Please Login or Register  to view this content.

Must be:

Please Login or Register  to view this content.

Or you can use this instead:

Please Login or Register  to view this content.

Perhaps you can try this...

Please Login or Register  to view this content.