Hi
from a religious perspective: Ascension Day

Though it's also 'father's day'. That means most male people (we are
not that strict regarding the 'father' part) are going on 'alcoholic
trips' outside :-)


--
Regards
Frank Kabel
Frankfurt, Germany


Bob Phillips wrote:
What holiday is it?


"Frank Kabel" wrote in message
...
Yes I do <vbg

you know we Germany have so many holidays.....


--
Regards
Frank Kabel
Frankfurt, Germany


Bob Phillips wrote:
No, do you? Our next is end of May.


"Frank Kabel" wrote in message
...
Hi Bob
you're welcome :-)

</OT
just wondering: Do you also have a holiday today in England?


--
Regards
Frank Kabel
Frankfurt, Germany


Bob Phillips wrote:
Thanks mate.


"Frank Kabel" wrote in message
...
Hi Bob
small typo :-)
.Offset(1, 0).PasteSpecial Paste:=xlPasteFormats

--
Regards
Frank Kabel
Frankfurt, Germany


Bob Phillips wrote:
Do you mean

With Cells(Rows.Count, "A").End(xlUp)
.Copy
.Offset(1, 0).PasteSpecial Paste:=xlPasteForamts
.Offset(1,1).Select
End With


"ADRIAN" wrote in message
...
Right, you ready?

I have used:
Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select

Is it possible to now continue the pattern that goes down
column A in this blank cell? To give you a better idea the
macro is to create a new part. so when it is run i would
like it to automatically enter the next part number and
move across to column B where the user can enter the
description.

I will be really impressed if anyone can sort this out.