Thanks Tom, once the solutions are in front of me, they make perfect sense,
that worked perfectly.

Thanks Terry for your contribution, I'm sure it would work too, but I was
already on this track, and didn't want to recreate the wheel.


"Tom Hutchins" wrote:

If you are going to manually select the rows, then you can just use Selection
in your macro (they are already selected). Or, Selection.EntireRow.Select
will work whether whole rows or just cells are selected.

Hope this helps,

Hutch

"carrera" wrote:

Very cool Jim. I inserted it in the right place, and so far, so gool
However, that uncovered a small glitch in my macro...when I was recording
the macro originally, my intent was to be able to highlight any 4 rows and
run the macro. But, the first line of the macro reads

Rows("14:17").Select

so of course it keeps taking those 4 rows.
How do I rewrite that line so it take whatever 4 rows I highlight, then runs
the macro?

Thanks


"Jim Thomlinson" wrote:

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