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....