OK ... I can see you're going to be real popular around here.

I personally had no idea what MT meant, so I don't know where you come from
where you claim it is common usage. Tom pointed out to you that you would
lose possible replies from people such as myself who didn't understand your
post. And he did give you an answer.

So if you're going to be ultra-sensitive to criticism, perhaps this is the
wrong place for you to hang out. Even the veterans and MVPs get criticized
here; no reason why you should be excepted.

Hope this helps!

--

Vasant



"Patch" wrote in message
...
Helping is one thing, being a condescending jerk is
another.

But I guess they're not mutually exclusive.

-----Original Message-----
Your not there now, are you?

Your here looking for help. Empty is the most common
notation I am aware of
for empty. Remember, this is a worldwide forum. Many of
the frequent
responders here don't speak English as a first language.
But I guess you
will have some cute response to that as well.

--
Regards,
Tom Ogilvy

"Patch" wrote in
message
...
Where I come from MT is THE common notation for empty.
We
don't consider it "cute".

Just trying to help you with the quailty of your
replies!

-----Original Message-----
There was something offensive in trying to help you
improve the quality of
your posts and make answering your questions easier?



--
Regards,
Tom Ogilvy



"Patch" wrote in
message
...
If you thought it was so "cute" then why did you
bother
to
reply?

Thanks anyhow!

-----Original Message-----
Using cute notation like MT to say empty just makes
it
less likely your post
will be answered. You interest is best served by
clearly, simply and
completely stating your problem.

Here is one possible interpretation:

Sub Tester9()
Dim rng As Range, rng1 As Range
Set rng1 = Worksheets("Summary") _
.Cells(Rows.Count, 1).End(xlUp)
Set rng = Range
("A10,A11,E22,F22,G22,H22,K60,L60,M60")

i = 0
For Each cell In rng
cell.Copy Destination:=rng1.Offset(0, i)
i = i + 1
Next
MsgBox "Pasted at " & cell.Address
End Sub

--
Regards,
Tom Ogilvy

"Patch" wrote
in
message
...
Hi -

My VBA knowledge is very limited. I pretty much
depend
on
the macro recorder to do my dirty work and I know
that
it's very inefficient. Here's what I want to do -

I have a template sheet that gets filled in with
data,
both numbers and text. I want to copy certain
bits of
this
data and paste it into a different workbook which
I
use
as
a summary.

The data I want to copy/paste is scattered
throughout
the
template and is for the most part in non-
contigious
blocks.
I can handle the copy operation but the problem
comes
when
I need to define the destination. I want the data
to
be
pasted in the next MT row of the summary sheet in
a
different workbook. If it wasn't for the last row
bit I
could just use a formula cell to cell link like
=Template!
A10.

Say for example I want to copy from the template
sheet
cells - A10,A11,E22,F22,G22,H22,K60,L60,M60 and
have
that
pasted into the summary workbook on the next MT
row,
which
might be row 12, in the range A12:I12.

I also would like a msg box that pops up and
confirms
that
the copy/paste was successful.

I can handle creating a button and assigning the
macro
to
it.

Any help will be greatly appreciated.

Patch


.



.



.