how to select a row in Excel and print only the columns we want With Macro

**arambar** · 09-12-2022, 12:20 AM

Hello friends, how are you?
I have a question, is it possible to select a row in Excel and print only the columns we want? With a macro?
I have a worksheet with 1000 rows and 30 columns. For example, if I select row 423 and press the macro button, columns a423, b423, c423 from that row will be prepared for printing

**Crooza** · 09-12-2022, 12:43 AM

Hi and Welcome

You could try something like this to print columns A to C of the selected range

Please Login or Register  to view this content.

**arambar** · 09-12-2022, 01:35 AM

hi thanks bro
I have another question
If I want to select these columns ("H","J","C","D"), should I write in this way for printing?

Please Login or Register  to view this content.

**Crooza** · 09-14-2022, 01:32 AM

Not sure you can do that. I would hide the columns I didn't want printed.

how to select a row in Excel and print only the columns we want With Macro

LinkBack

Thread Tools

Rate This Thread

Display

how to select a row in Excel and print only the columns we want With Macro

Re: how to select a row in Excel and print only the columns we want With Macro

Re: how to select a row in Excel and print only the columns we want With Macro

Re: how to select a row in Excel and print only the columns we want With Macro

Thread Information

Users Browsing this Thread

Similar Threads

Macro to select Print Areas in Excel to PowerPoint

[SOLVED] how do i print select combinations of columns in Excel?

Create a print macro that would automatically select print area?

Create a print macro that would automatically select print area?

[SOLVED] Create a print macro that would automatically select print area?

[SOLVED] Create a print macro that would automatically select print area?

[SOLVED] Create a print macro that would automatically select print area?

Create a print macro that would automatically select print area?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions