Macro loop crashes excel?

[Lagitup]

Hey all
I'm trying to write a macro to update a sheet with new entries from another sheet. The loop I am trying to use to select the first empty cell from the top of the updated sheet crashes or doesn't stop looping when I run it. I have tried using While...Wend, If...Then, and For...Next. I have also tried incorporating a Goto: statement into it. Can anybody tell me what I am doing wrong here?

Please Login or Register  to view this content.

[shg]

To select the first empty cell below A2,

Please Login or Register  to view this content.

To select the first empty cell below all used cells in column A,

Please Login or Register  to view this content.

[Lagitup]

ok, thanks! That is working, but now i have another issue.

Please Login or Register  to view this content.

That fills the cell with =name!$Q:$Q rather than =name!c16. I've also tried

Please Login or Register  to view this content.

to the same effect. Why wont it put the correct value in?

[shg]

Please start a new thread with your new question.