I have added a command button into my spreadsheet which prints all sheets at
once.  However, I only want to print some of the worksheets.  I only know the
Visual Basic code (ActiveWorkbook.PrintOut) for the entire workbook.  Can
anyone tell me the code to print only select ...

I have the following code in my PC version that works without error,
could someone tell me how to modify it so that I can have it open in a
MAC version?
pathname = ActiveWorkbook.Path

I've got a spreadsheet that a number of users around the company update and
send back to me - however they add columns and change stuff so it never comes
back the same as I sent it out.
Am I able to reset back to the original view but somehow include their added

I have over 2,000 entries in one spreadsheet, with revenue figures in column
H, and the figures are sorted ascending
To provide the user with a quick overview on a printout, I wanted to
"compress" everything so it would fit onto one landscape-oriented page. By

I've tried, but I can't figure it out.  How to use conditional formatting to
alternatively color rows based on values in a column?  
For example, in B13:B3000, I have values like this:
Col B           Row color I'd lilke

Any good recommendations for some basic and moderate VBA/macr
programming?
I have been teaching myself and having a read on here, my knowledge i
very patchy!:

Hi please help me out on this...
Everytime i save the file, the file name should be changed to test1.xls;
second time i open & save the file, the name changes to Test2.xls & so on....

Presently I am learning VB. I prepared a GUI for Excel.
My basic intension is ...
As we entered values in GUI, it should open MSExcel file(which is
already there in my local drive), print all these values in the

For instance, if I have a listing of 1:30, 0:20, 2:20, 0:03, and 1:30
(representing minutes and seconds), how do I obtain the average minutes and
seconds of these 5 numbers?  Thanks!

I want to print a sheet with the upper left point being A1 with the bottom
right point variable.  I could put a word in the cell (i.e. corner),  I need
a macro to look through the sheet and find the word "corner" this would then
be used as the bottom right point for the print ...

I have stuck in a problem,
By running a macro i should be able to sum a range of variable data.
Eg:-
sum of  A1:D1 in E1 or

can anyone advise how to use this solversolve option Showref:=.  As far as I
can determine it takes a string argument - the name of a function,
'Showtrial' is the example used in the documentaion I can find anywhere.=.  
However all my attempts to use it to take control of the ...

I am creating a program where I need a variety of buttons and check
boxes that do stuff to the excel sheet. Just using the excel forms
doesn't work because when I zoom out (which the program needs to be
able to do), the buttons get small and unreadable.

I am attempting to create an excel worksheet where when a user clicks on a
button (located in a cell), the worksheet will scroll to a pre-determined
location in the worksheet. My problem is that the only means I can find of
specifying the location to scroll is by supplying a ...

I seem to have misplaced a function.
What is hte method for counting how many times a specific character occurs
inside a string without looping through it?
eg...