Why won't my Do while run?

[Cluv]

i'm trying to create a macro that transfers a set of data from one sheet to another on the condition that the first row has text in it (in my case a name). It's supposed to stop when the first row is out of names starting after row 52 on the first sheet. I'm writing test code to see if it functions correctly but it only runs once. I'm starting the copying at row 52 on the first sheet and then transfering it to a second sheet starting on row 8 and from then on go row by row until sheet 1 is out of text. The first sheet is "Master Input for year."The from. The to is to the "quarterly NPI" Here's the code. Any help is appreciated.

Please Login or Register  to view this content.

It looks right to me. Why won't it work?

[Leith Ross]

Hello Cluv,

Welcome to the Forum!

It stops running because cell A53 is blank.

[Cluv]

Cell block a53 is not blank. that's the confusing part. There's data from row 52 to row 92 in the first sheet.

[Cluv]

I fixed the problem, it turns out I have to rereference the sheet i want to copy from at the end of the Do while.

[watersev]

hi, can you post sample workbook the code is not working properly on?