how to loop though a cell range in VBA

[jeskit]

Hi

Des anyone know how loop though a cell range ("F4-U644") and say If the cell is empty move to the next one else add the value "1" to the cell?

Thanks

Jeskit

[tlafferty]

By add 1 to the data in the cell, do you mean:
put a 1 at the end of the data: abc===>abc1
or replace the data with 1? abc===>1
or add 1 mathematically? 12345====>12346?

[jeskit]

hI

Sorry i shold ahve been more specific.

I meant i want to replace whatever data that is in the cell the "1"

thanks for replying

[incjourn]

Is this what you are looking for?

Please Login or Register  to view this content.

[jeskit]

Hi

Yeah thanks for your help!

However is mycell supposed to be a variable?

Thanks for your help

[incjourn]

Yes, mycell is a variable. You can use another variable name if you like.

[jeskit]

Thanks for your help I greatly appricate it thanks