New Users to Excel | Forum profile

Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "A1:A10" Dim cell As Range On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then For Each cell In Target cell.Value = cell.Value / 1000 Next cell End If ws_exit: Application.EnableEvents = True End Sub Right-click on the sheet tab and "View Code". Copy/paste the above...

One way... =MAX(0,your_formula) =MAX(0,B1-A1) -- Biff Microsoft Excel MVP "Ken" > wrote in message ... > If a formula gives me a negative number, I want to disply it as zero. > Can > you show me how to make that work? In other words, if a formula creates a > value of > "-14", I want it to show up as "0" in the cell.

I have a Template for the 52 Weeks that i created if i want to change something in Template is it possible to have the 52 other sheets change as well through Macro,s if possible How

1) http://www.esm.psu.edu/courses/emch1...uler-tutorial/ 2) Google with: Excel Euler's method 3) Send me private email and I will send you a PDF of the relevant chapter from my book 4) Buy my book <grin> best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Blair" > wrote in message ... > Hey everyone, > > I have a math project I am doing. This is...

Use local/worksheet level names. Select the range and include the sheet name in the namebox when you create the name, like: 'Sheet 99'!myNameHere Jim wrote: > > I have a workbook with multiple worksheets, the worksheets are structured > identical to each other. I need to name certain ranges in each of the > worksheets. On the first worksheet, I was able to name the ranges without > difficulity,...

Thanks Dave, I'm just now getting around to reading your memo. I probably just set it up wrong. I may have clicked on the "number" on the extreme left of the sheet instead of an active cell. I'll give it another try tomorrow and let you know how I come out. Thanks again, Doug "Dave Peterson" > wrote in message ... > I'm not sure what mark means here, but freeze panes will freeze...

Sunir, Well, then, that is your criteria. Create your list of critical jobs of interest (on perhaps, another sheet named Critical Jobs), and use a formula like =NOT(ISERROR(MATCH(CellValue,ListOfCriticalBackUpJ obs,False))) like =NOT(ISERROR(MATCH(A2,'Critical Jobs'!$A$2:$A$400,False))) and filter your list to show those that return TRUE. -- HTH, Bernie MS Excel MVP "Sunir M S" > wrote in message ......

This can be done with VBA code (a macro). You haven't given enough information to provide a more detailed answer, but there is one command available that does allow you to browse and identify files to be worked with that will probably end up in the code: Application.GetOpenFilename will return a filename from a dialog box, and then the code can open that file and perform operations to copy information from that file into another...

HI Bernie Actually thers no logic other than string matches. I am a backup administrator. I receive a report of about 1000 database backup job status at the end of day with completed times and date. Out of that i have some 400 critical backup jobs that i am interested in which has to be filtered out and published and the rest should be removed. What i do is a tedious task of deleting each job that is not critical one by one to finally have a...