$$Excel-Macros$$ Print only A3:K

2011-06-05 Thread Bob
How do you write a macro to print Sheet1, A3:K only. Nothing from L over. Thanks in advance!!! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

$$Excel-Macros$$ Print area that has data

2011-06-05 Thread Bob
Is there a way to print the rows with data in them and not print the rows with just the formula. My spreadsheet has several rows with formulas in them and I only want to print the rows which I have added data. I know you can select print area and all that. But mainly it's for the inexperianced user

Re: $$Excel-Macros$$ Hyperlink for Sheet in a Cell - changes

2011-06-05 Thread Dilip Pandey
Hi Charlie, Yes it is possible, check the attached file. Let me know if this is what you are looking for. Best Regards, DILIPandey On 6/4/11, sswcharlie wrote: > Hi > > Is it possible to have say a cell with hyperlink to sheet (that is ok) > but also if the name in that cell changes it stays a

Re: $$Excel-Macros$$ get more and more knowledge

2011-06-05 Thread Dilip Pandey
Nice briefing :) Best Regards, DILIPandey On 6/5/11, rosini wrote: > Microsoft Excel has the basic features of all spreadsheets,using a > grid of cells arranged in numbered rows and letter-named columns to > organize data manipulations like arithmetic operations. It has a > battery of supplied f