Hello, Could someone help me understand why it doesn't like "If cUser = "XJOHN" Or "YPAUL" Then" in the macro below? Thanks. Sub UnprotectAllSheets() Dim...

I've very limited knowledge regarding programming in VBA, and would like to create a control button whereby hyperlinked objects within excel cells can be...

I have a list of over 1000 names in my a column but need to add @gmail.com to the end of all of them. How can i do that in excel?

hellow i relly dont know too much about excel... and they ask me to do this: i have 1 column with ID of employees, like: E01,E02,E03. and each id, has a name...

Hi Don, As promised latest test figures by area these include David's latest tests. -- Steve

I would like to create a query. .. ie. NFL sched for 2005. on the 1st sheet that pulls individual team info from the 2nd sheet. So I will input a team, and...

I have a spreadsheet that has 4 columns. H=Month, ex 4 J=Day , ex 1 K=Year, ex 5 L=Century, ex 20 How can I gather all of these fields so that it can look...

How do I display a number in thousands or millions without rounding the number? For example, I would like to see 52,569,832 displayed as 52,569.

Excel 2000 SR-1 I am trying to write a VB code using a For - Next statement to calcualate cells. The basic satement is: For X = 1 to 7 = {Calcualtion} '...

I have a worksheet that I use to keep track of my time spent on projects. right now I just enter the time in manually and have formulas to add up the time. I...

Is there a file that holds user data such as page break locations that could be transferred to a new machine?

if we enter number(500) in cell A1, can we display it as five hun...

I downloaded microsoft excel 97 viewer on my pc and I can't open it.

Hi, How to express the following formula in Excel format; Formula 1 , ((A3+B3)/2)(B30/365) Formula 2 , ((A5+B5)/2)/(B31(365)) I did try but not success.

I have macros in my file. When I open it I get a msg: Cannot find 'C:\Program files\Microsoft Office\Office 11\Library\Msquery\Xlquery.xla'!Register.DClick,...

How do I add a dropdown list in a spreadsheet? for the user to select from

I have 4 columns of data first column is a list of US cities second columns is the change in population from 1990 to 2000 for the cities in the first...

my cursor is a cross and i cannot use it to drag formulas. please help.