How to printout only selected rows and columns
 

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

How to printout only selected rows and columns
 

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

How to printout only selected rows and columns
 

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

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)

How to printout only selected rows and columns
 

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)

How to printout only selected rows and columns
 

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)

How to printout only selected rows and columns
 

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)

How to printout only selected rows and columns
 

Mmmmm.

So the gist is that you want to select an area and print it from a macro
(button I guess)

2nd bit, was to remember the columns and on subsequent range selections
just alter the rows (using the previous columns)

Your macro works - but only for the area you hard-coded in.

Off to think - sorry

Steve

On Thu, 31 Aug 2006 18:51:44 +0100, Gina M. wrote:

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

How to printout only selected rows and columns
 

How about:

Sub PrintSelection()
Selection.PrintOut Copies:=1
End Sub

That will send whatever you have currently selected to the default printer.

"Gina M." wrote:

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)