How to printout only selected rows and columns
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)
|