Find Non Blank Cell and run Macro

**Vetequk** · 01-23-2010, 03:17 PM

I am try to write a bit of code which will find the non blank cells in column H (Range H4:H24) and when it finds a non blank cell make column C in that row the active cell and then run a macro. Once the macro as been run i would like it to look for the next non blank cell.

At this moment I do not have any idea where to start with this so any help would be appreciated.

Thanks Vetequk

**Palmetto** · 01-23-2010, 03:36 PM

What is the other macro supposed to do? You don't have to activate cells for other code or actions to be done.

Basic code framework:

Please Login or Register  to view this content.

In order to get a more precise answer, upload a sample workbook and provide more details about what is expected.

**Vetequk** · 01-24-2010, 05:28 AM

All the macro does is take certain information off a excel spread sheet and copies it to a new sheet and gives the new sheet a name. the trouble is some of these sheets have over 100 names. I have attached a test sheet I was working with.

Thanks for your help

Vetequk

**royUK** · 01-24-2010, 05:51 AM

You can use Specialcells

Please Login or Register  to view this content.

Just seen your example workbook so I will take a look

**royUK** · 01-24-2010, 05:55 AM

Your existing code has way too many unnecessary actions - Selecting, Activating etc.Maybe if you could state exactly what the code is required to do,provide a before & after example, the code could be improved

**Vetequk** · 01-24-2010, 06:11 AM

I am looking for the code to run through the test spread sheet, extracting only the rows with information in the comments column. Then create a separate sheet with only certain information from that row.

In the comments section it may say visit this client on the 3rd February. the code will create a sheet with the clients details and the sheet would be issued to one of our operatives to action.

Hope that makes sense.

Thanks
Vetequk