I was unable to make this loop work the way that I wanted to. TO make it work I had to add a Goto. I hate these but find them necessary when I get stuck in a...

In Excel 2003, I have a workbook with a lot of worksheets. I know how to email just 1 of the worksheets, but how can I save just one worksheet to a stand...

I am having problems opening Excel 2007 documents from Explorer. I have read through the other threads and tried Excel Options/Advanced/General/Ignore other...

Hi We are using Office 2007 and are experiencing problems with the shortcuts in Excel 2007. When some of our users want to type a D (capital d) in a cell...

cell shaded lite gray prints dark gray -- el

I have several excel documents (templates) all with the name xxx_Testprotocol1, xxx_Testprotocol2 etc. For each test campaign I need to replace the xxx at...

Hi there, I have Names in column A starting A2, and Starting Month (mmm yyyy) in column B starting B2. Across the top starting C1:Z1 I have 24 months (Jan 07...

I have to regularly open several workboks at once with most of them linked to many other worksheets. I want to be able to display the links of the workbook...

Hi, IF A2 is the referce cell for the if formula & reuslt cell is A1, If i cut A2 Row & palce it in A3 the refrence cell should be to the same...

I’m trying to do an IF OR statement, but I have something wrong. I currently have: Columns P, U and AB are formatted as a custom date. Column AC...

Hi there, I have discovered that there seems to be an upper limit for spin buttons. I am trying to create one that will allow the user to enter anything...

I want to copy excel information from same cells in different sheets and paste unto the same sheet , how can I use macro or anything else to do this without...

Hi all Is it possible to open a ,for instance, a" Canon Scan Program" from a Hyperlink? Best Stew

Is there a way to run a regression analysis with input data that contain some null cells? I have a large matrix of data within there are many cells...

Hi I am using a large excel file, in both 2003 and 2007 versions. The data contains exam results based on exams 6 years apart and looks like this. KS2...

I have a student marking sheet with 2 colums, one is "Individual grade" for each subject, and the second for "Overall Grade". what i am trying to do is use...

Hi, I'm extremely new to using macro's in excel. I haven't been able to do more than recording one and simply editing it in the vb editor. What i want is...

X Y Z 1 5 3 5 2 ? 4 3 3 ? 6 2 ........................ ........................ Using solver in excel 2007, i did an iteration for row1 alone,...

I am looking for methods to calculate the error in a slope. the caveat is that my values themselves are averages with a...

What formula would accomplish: If no comma found in A1 then... -- David P.