check if sheet empty then paste value

hi expert,
need ur help.... i would like to write code that will:
1) active sheets--> is range a1 empty?
2) range a1 = empty --> then paste value
3) if range a1 <> empty --> open next worksheet
4) is new sheet range a1 = empty--> then paste value

this will loop until i have nothing to paste..
please help....

One quick question. Were are you copying from? Or is this something that is going to be stored on the clip board.

Try:

Please Login or Register  to view this content.

Edit the copy line to match whatever you require

Probably a more crisper way:

Please Login or Register  to view this content.

hi stnkynts..!!!
thanks a lot...!!! it help...!!!!!

hi,
i found out that i was looking for others logic which is ;
1) if active sheet range A1 <>"" then will select next sheet and activate it and end
2) if select next cell is error, which mean do not have next cell, it will add a new sheet and activate it....

Please Login or Register  to view this content.

i found above code will add new sheet then look range a1 is empty or not.