Here is some code that will find the first blank cell in a column...

cells(rows.count, "A").end(xlup).offset(1,0).select
What this is doing is it it going to Cell A65,536 and then traveling up to
the first cell with data in it. It then offsets down 1 cell to give you the
first blank cell.
--
HTH...

Jim Thomlinson


"carrera" wrote:

I'm creating a spreadsheet with 10 tabs, each one being a different hosptial.
Each section of rows on a sheet will contain various patient information (4
rows per patient)

For when patients transfer from one hospital to another, I'm going to have
hyperlinks so the user can highlight the information on one section of rows,
of let's say Southside Hospital, click on the hyperlink, and have the
information cut from that section (deleting those rows) and pasting into the
next available section in the receiving hosptial, let's say Northside
Hospital.

I'm recording other macros on each sheet for other purposes, but I don't
know how to get it that the information won't be pasted over existing
information on another patient.

Thanks