hi, Is there any way of either hiding the cursor or restricting it to a few cells? I have mastered the scroll area so the template wont move, but the cursor...

I have a sheet of business data. There are 3 locations of service and I want to count the numbers of sales in each location over a given time period. Column C...

I need to record a macro that allows me to save the workbook with another file name. I cannot stop the recorder with the 'Save As' window active. My workbook...

All, At work because the email exchange blocks spreadsheets with VB macro's in them I need to remove the below code I have in one spreadsheet: Private Sub...

Hi, I find this very puzzling. I have 2 cells with the following values. -2.53948423496706E+64 (say =t) -4.04686094372251E+96 (say = m) Now I have 2 other...

I know how to look up data and text using vlookup and hlookup, what I'd like to know is whether there is a way of looking up data based on more than 1 search...

I have protected my workbook and can't remember the password. Is there any way to recall, or override the protection?

Ok, that was easy for you guys but..... I have now another problem totally related to this matter. I have 3 columns of data, NAME, DATE,TEXT NAME Date ...

Hi, I'm trying to create a slideshow with one excel table rolling across several slides. The data will change and needs updating monthly; I want to be able...

newbie question.. I have 5 cells (A2:E2) which have different percentages the headers of these cells (A1:E1) have year-end date eg. 12/31/2004, 12/31/2005,...

Excel 2003: I need to search a value in worksheet (2) that exists in worksheet (1), confirm if it status, in the same row but another column, is "ok" or "not...

Greetings, I am having difficulty looking up an item using two-column lookup formulas as suggested. Following are the parameters of my situation 2 Different...

Hi all I'm trying to create a spreadsheet that returns data from another shared worksheet used by a number of colleagues. Is it possible to have a formula...

Hi I have a list of names and addresses which are all listed in column on vertically but I need to change it to horizontally without having to retype all the...

I have columns A and B filled with information. The information in A1 refers to B1, A2 to B2 etc..... In some of my cells, there is duplicate information, and...

I'm trying to get the following formula to work. I16 is a data validation list (drop down list) and I keep getting the circular reference error message, can...

Does anyone know of any way to format the output of an if statement? I'm looking to do a very simple if statement and then based on the output I want the text...

Cannot use the shortcut 'ctrl+shift' when selecting within existing table- but am able when create new.

Sorry to post this here and on Developer page, but hopefully one of you VB experts out there can help clarify something for me. I want to learn VB and can get...

I want to be able to "Copy and Paste" one Sheet to another using the Excel Com component for version 2000. At the moment I have written something like the...