Steve
unbelievable ... I meant Excel ....
2000 ... I was probably thinking about better using access and wrote ...
ashes on my head

Gina

"SteveW" schrieb im Newsbeitrag
news:op.te5p74flevjsnp@enigma03...
I'd answer, but I don't use Acess so can't quite help

Steve

On Thu, 31 Aug 2006 17:32:39 +0100, Gina M. wrote:

sorry ... I may then have to find a different forum ?
I am too new to even find my way through here

thanks anyway
Gina


"SteveW" schrieb im Newsbeitrag
news:op.te5o2smtevjsnp@enigma03...
This is an Excel forum :)

Pilot's answer assumed you wanted the headers printed - because you
mentioned them.

Steve

On Thu, 31 Aug 2006 13:07:16 +0100, Gina M. wrote:

Hi Pilot.

Thanks for your answer .... but unfortunately it is not what I need in
this
case, I think
what I have tried so far is:

***********
Sub PrintMySelection()
Dim strTopLeft, strEndRight As String

strTopLeft = "$A$2"
strEndRight = "$E$3"
ActiveSheet.PageSetup.PrintArea = strTopLeft & ":" & strEndRight
ActiveSheet.PrintOut
ActiveSheet.PageSetup.PrintArea = Null

End Sub
************

What I would rather like to have is a more dynamic approach ....
whatever rows and columns I select
say next time ... I would like to have row 5-15 ( because I have
selected
them)
... same number of columns though

maybe someone can point me to right direction
(I am using Access 2000)

Thanks, Gina


"WLMPilot" schrieb im Newsbeitrag
...
Under FILE on the menu, choose PAGE SETUP Sheet. You should see two
options: "Rows to repeat at top" & "Columns to repeat at left" I have
not
used the row option, buth if the headers were in column A, I would put
A:A
in
the Column option. Then highlight what continues columns I wanted to
print
and the appropriote headers in column A would print. Maybe you just
have
to
enter 1 for the Row if you want row 1 to print as stated.

Les

"Gina Meyer" wrote:

Hi all.

here's my problem:

I have a sheet with headers: first name, surname, address1, address2,
someotherstuff
I would like to select some rows (continous) and appropriate columns
(continous) and get a simple printout of the selected data. ... for
now
Later I would like to fomat this data in order to get proper labels
as
prints.

I am sorry ... I haven't a clou how to start this reasonably and
would
appreciate your help !!

TIA

Gina











--
Steve (3)