nested loop for copying range: error no cells were found

**Edejager** · 04-09-2013, 07:27 AM

Labflow Lite.zip
Hi,

I have a problem with this code. Excel give the following error: error 1004: no cells were found.
This sub should selected multiple ranges and look for blank cells in that range.
Sheet11 is completely empty, so I do not understand why excel cannout found cells.

Can anyone help me with this?

The code is in module 10 and 11 (almost the same code just the range are different)

Please Login or Register  to view this content.

Thanks

**AndyLitch** · 04-09-2013, 07:56 AM

Syntax error in the line Sheet2.Cells(i, "Q").Copy

You need a numeric value where the Q is..

**Edejager** · 04-09-2013, 08:02 AM

Thanks,

but where the Q is, is dependent on what is filled in the first sheet (and this can be anything text or numbers or both)
So how can I write the code so that where the Q is, it can be anything. (but not only a numeric value)?
Can you help me with this?

Thanks

**AndyLitch** · 04-09-2013, 08:10 AM

But if you want to refer to a cell location using cells then you must use integer values to specify the location. Text won't work.

You need to find a method of calculating which column you want the data to go into..