Recent content by cutestuff

Sorry - found out it was because of conditional formatting. I had to enclose the table names in quotation marks. My brain wasn't functioning well working late yesterday... Thanks for the help though.

I am almost certain the table names are correct as I have been using them on formulas everywhere else on the spreadsheet. I am trying to enter this formula in the Conditional Formatting section though - does that make a difference? And thanks for the help!

hi there, For some reason I cannot get this code to work no matter what I tried. I have a table called tblTracker in excel with the columns Name, Start Date and End Date. The table starts on Row 6 (Row 5 are the headers). Column D is the Start Date Column and Column E is the End Date Column...

It is located on the same folder as everyone needs to access that one file. But I do believe it's got something to do with security/trust settings.

hi there, We have an accde (Access 2007) db that everyone can open except for one person. She can open accdb files fine but when I tried to open the accde on her computer, it just opens Access (to the general screen - you know, where the db templates are and stuff). We have the security warning...

Thanks again :).

wow - I didn't know that. Thanks, mscallisto! I thought it is 'implied' that all variables declared in that line would be type String. Thanks also Lee Nash - I will try your suggestion. :) It looks 'cleaner' than mine. :)

Thank you! :) That worked! I didn't want to hard code the range. :) You are pure genius!

hi, I'm not quite sure how to make this work (I think I'm close). The paths to the files are stored in cells in Column B. I would like to loop through each row and grab the path and copy the file. So far this is what I have: Dim fso As Object Dim cPath, nPath As String Dim x As Range...

Ok...maybe this will help: I3 holds the value for completed pieces for a particular item. H3 is the TOTAL number of pieces (completed or not). Which is why if the TOTAL is zero (H3=0), I can assume that I3 will be zero (no items = nothing complete). Does that make sense?

Not sure what you meant there...

The reason I said this formula will just work in this particular instance is when H3 is ZERO, I3 will ALWAYS be zero. That's why I was just putting H3=0 in the beginning - putting I3 =0 also will be redundant.

I just changed the formula to: IF(H3+I3=0, "", H3-I3) It seems as though if I just put H3=0 it doesn't read the result correctly. But if I put some type of calculation in the first part it works. Like I said, it worked for my particular situation but it's still not my ideal solution. :)

Oh. I think I kind of solved the problem. I just manipulated the formula. It worked for what I needed for now. I still don't know why the above didn't work but oh well.

hi Skip! H3, I3 and J3 all have formulas. H3 and I3 are Vlookup formulas that return a number. J3 just has the formula: =H3-I3 I think looking at it closely it seems as though it's not reading it as 0 because of the formula? Is there a way around this? I tried conditional formatting too but same...