Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have a excel print Macro that is just not working

Customer Question
correctly. It is not printing...
I have a excel print Macro that is just not working correctly. It is not printing all the Data. Please look at the "New Assembly Sheet" and click the print button. The macro only prints partial results. Please fix!
Submitted: 2 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 6 minutes by:
3/7/2016
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 8,144
Experience: Computer Software Specialist for more than 10 years
Verified

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

I am very sorry about your issues. Can you please attach the XLSM (macro-enabled) file here? You can use the paper clip icon to attach it. Or you can upload it to http://filesXpress.com and give me the short download link.

Please let me know by replying to me here so that I can help you further.

Best regards,
Jess

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
Here you go...Im trying to print so that all columns are on one page and the rows that have alll zeros dont appear and that it takes up no more than two pages....
http://filesxpress.com/download-d63e55d19dbfb416759655621927104f
Customer reply replied 2 years ago
http://filesxpress.com/download-d63e55d19dbfb416759655621927104f
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thank you for the link. Please give me a moment to download and check the file.

Jess

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
ok
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thanks

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

I got your file and the printing worked. What specifically you want in the printing? You mentioned about NOT printing the rows with 0s. What specific columns with 0s are you trying to NOT include in the printing?

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
It doesnt print all the correct rows
Customer reply replied 2 years ago
It prints only one page and then just a header of second page
Customer reply replied 2 years ago
Its missing most of the rows....
Customer reply replied 2 years ago
please review the macro
Customer reply replied 2 years ago
Sub PrintData()
Application.ScreenUpdating = False
Rows("1:160").Hidden = False
Columns("A:B").Hidden = True
For i = 3 To 160
If Cells(i, 7) = 0 And _
Cells(i, 8) = 0 And _
Cells(i, 9) = 0 And _
Cells(i, 10) = 0 And _
Cells(i, 11) = 0 And _
Cells(i, 12) = 0 And _
Cells(i, 13) = 0 And _
Cells(i, 14) = 0 And _
Cells(i, 15) = 0 And _
Cells(i, 16) = 0 Then
Rows(i & ":" & i).Hidden = True
End If
Next iActiveSheet.PageSetup.PrintArea = ""
ActiveSheet.PageSetup.PrintArea = "$C$1:$Y$160"
With ActiveSheet.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 2
End WithActiveSheet.PrintOut
Rows("1:160").Hidden = False
End Sub
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

I printed in PDF, and here is the printout file. Is this printout correct?

Here is the link:

http://filesxpress.com/d-763d64ae

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
is it not working for me , because I am on a Mac?
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thank you for that confirmation.

If that is the correct printout, then that is printed using the blue PRINT button in the sheet named "New_Assmbly_Sheet", and NOT from the File => Print dialog box.

Also, please check your print area settings on your Excel to ensure that the print process is not restricted by your print area settings. Then try printing using the blue PRINT button on the sheet.

Keep me posted.

Jess

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

8,144 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I have an excel question. I have a database download
I have an excel question.I have a database download worksheet with data sorted in columns. The first column is the all model numbers with multiple part descriptions for each model (i.e. 30-40 parts wi… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Please see the Sheet titled “MasterLabelFile” and the sheet
Please see the Sheet titled “MasterLabelFile” and the sheet “MasterLabelBrands”. MasterLabel File has a complete list of the menu items we are making, along with ingredients and the nutritional info a… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
In excel, how do if I use index match formula or it can be a
In excel, how do if I use index match formula or it can be a vlook up. How do I change the data only if it doesn't match but if it matches to keep the information in that cell?… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I have generated an excel spreadsheet, where I am recording
I have generated an excel spreadsheet, where I am recording results for a race. The results are compiled as one large group, that includes several age group categories. I would like to be able to have… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I currently have an excel table (8 columns, 422 rows; 1st
I currently have an excel table (8 columns, 422 rows; 1st row table headings) which I will call Table 1. Additional rows will be added daily with new data. I need help in creating a copy of this table… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
Using Excel 2013, search all cells in Sheet contained
Using Excel 2013, search all cells in Sheet for value contained in A1; if found (including partial hits), display entire row (or rows) in designated area. Have 1-page file containing data base and exa… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I have created macro buttons where I recorded my actions of
I have created macro buttons where I recorded my actions of using the filter in cell P11 (PushUps) and then select Number Filters and then Top 10, then I copied these results to a new sheet called “To… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Now my second issue is a little more complicated at least
Now my second issue is a little more complicated at least for me – earlier in the week you created a Macro for me that will print a hard copy (Line Graphs) for ALL the students that are contained in t… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
For Jess M: Microsoft Excel Question:I have four data
For Jess M: Microsoft Excel Question: I have four data sets I want to combine as one data set and feed all the data into a pivot table. Each data set is defined as a range in its own worksheet. Doing … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Hi. I have a large excel SS. I need to populate an A4 page
Hi. I have a large excel SS. I need to populate an A4 page list with selected rows of data chosen within a large list (currently 3500 rows). I have created a test sample, which includes an existing ma… read more
Brandon M.
Brandon M.
System Administrator
Vocational, Technical or Trade Scho
2,143 satisfied customers
Hi Richard, Tried to protect everything on my worksheets
Hi Richard, Tried to protect everything on my worksheets but the couple of ranges that people should be able to enter data into. Pretty straightforward except that one of the ranges I'm selecting cont… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
Not sure if my question should be asked here under VBA or Excel.
Not sure if my question should be asked here under VBA or Excel. I'm trying to create a simple macro to look at a row of data, if there is a match in a cell to hide that specific column and then move … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I have a excel program that has 1 sheet give the info for another
I have a excel program that has 1 sheet give the info for another sheet, then I run a macro that saves each sheet separately in a different folder the problem I am having is when the sheet gets saved … read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
I have created a Customer Information spreadsheet with numerous
I have created a Customer Information spreadsheet with numerous tabs and macros. I am trying to do a LOOKUP on the word "Existing" in sheet "Account Growth" at $C$59, and look for all matches from Tab… read more
Ryan-CTech
Ryan-CTech
Manager
279 satisfied customers
How to set searches within excel to default always to the top
How to set searches within excel to default always to the top of spreadsheet for multiple sheet searches… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have an access 2000 database with 3 tables that Id like
I have an access 2000 database with 3 tables that I'd like to export into sheets in a excel 2000 spreadsheet. The record count in the 3 access database tables are over 1 million. How do I export this … read more
Techie_Ben
Techie_Ben
Software Engineer
Master\u0027s Degree
1,444 satisfied customers
Hello,I am very new to Excel and cannot get my head around
Hello, I am very new to Excel and cannot get my head around macros. It doesn't help that I am also blonde! I am using MS Excel 2003. I understand that my approach is probably not the most efficient, b… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
excel formula that takes data from multiple columns and condenses
excel formula that takes data from multiple columns and condenses it to remove blank cells. example. My data looks like this Yes (blank) Yes Yes Yes (blank) (blank) Yes i want it to look like this on … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x