Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sfvb
  • Order by date
  1. sfvb

    Site critique

    I am not a web designer (I have a lot to learn in that area), but I would like a critique of my site http://www.threadbender.com. For the person that might visit/revisit my site, I thought a simple, clean site was best, so that's what I was shooting for. I know I could speed up the Java...
  2. sfvb

    Sorting an array

    I think this is what you want: Sub ArraySort() Dim arrCol() As String Dim arrTmp() As Long Dim YourString As String Dim SortedString As String Dim strTmp As String Dim lngTmp As Long Dim idx As Integer YourString =...
  3. sfvb

    Spelling

    Thanks for all your comments. Steve
  4. sfvb

    Spelling

    Just a general question. I haven't had a client from outside the US yet, but there are a couple pending. Both small commercial sites from Canada. Is it ok to ask the client what country his target audience is from? It feels like an inappropriate question to ask. The reason I ask is, I do most...
  5. sfvb

    .net .biz or .com??

    Actually .govs and .orgs can sell products also. http://catalog.usmint.gov/
  6. sfvb

    Excel IF Formula Question

    Raymond, Sorry, I was answering as you posted. =IF(LEFT(A1)="L","Board Feet", "Square Feet") will work for what you described. Steve
  7. sfvb

    Excel IF Formula Question

    It sounds like you're trying to use a nested IF statement... =IF(A1="Butternut","Board Feet", IF(A1="Hickory","Board Feet", IF(A1="Quarter Sawn White Oak", "Board Feet", IF A1="Baltic Birch","Square Feet",... Since you only have 2 outcomes, Board Feet or Square Feet, (3 if you want to code for...
  8. sfvb

    how to freeze horizontal & vertical at same time ?

    Here's an example of how to freeze the rows above row 3 and to the left of column E: Go to cell F4 select Window-->Freeze Panes Steve
  9. sfvb

    A Question about Excel's Column and row limit

    fabraldr, I can't say what MS's reason for limiting Excel to 256x65536 is. My assumed answer is that a byte can hold 256 discrete values, and a word (2 bytes) can hold hold 65536 discrete values. I'm sure they could program Excel to handle more rows and columns. However, I think if a...
  10. sfvb

    Pronunciation: "S.Q.L." or "sequel"?

    Have a star for making me laugh. I'll add the one that bugs me the most: NIC card Steve
  11. sfvb

    SUM FORMULA PROBLEM EXCEL

    I think this will work: =IF(AND(C82>0, C82<13), SUM(Forecast!C53:Forecast!OFFSET(C53,0,C82-1)),"") As an example: If C82 contained the value 4, then OFFSET(C53,0,C82-1) would evaluate to OFFSET(C53,0,4-1) which would evaluate to OFFSET(C53,0,3) OFFSET(C53,0,3) evaluates to (C53 + 3 columns)...
  12. sfvb

    if and statements additions

    I guess if you think of any increase over 0 a %100 increase, then you would think of any decrease over 0 a 100% decrease. In that case... =IF(D11=0,SIGN(G11),(G11-D11)/D11)will work. Steve
  13. sfvb

    if and statements additions

    I can't say I agree with what you that the %increase from zero to a non zero number is 100%, but ...=IF(D11=0,ABS(SIGN(G11)),(G11-D11)/D11)will work. Steve
  14. sfvb

    Version of Internet Explorer

    MHUK, Having the tenacity to keep working on a solution, after asking for help, is worth a star in my book. Steve
  15. sfvb

    Select box IE question...

    Rob, The only way I've found to right-align the OPTIONS of a SELECT tag using IE (at least easily), is to use: direction:rtl; in the css of the SELECT tag. I believe this only works in IE5 and higher, and would be ignored by other versions and other browsers. Example: <html> <head>...
  16. sfvb

    Login to website???

    Hi LJA520, There are 2 different ways that a username/password form can be passed to the server, (the POST or GET method), both can be automated using either the msinet.ocx or the shdocvw.dll. (I find the shdocvw.dll easier to work with.) If you could post the url of the site you're...
  17. sfvb

    Get cell reference based on value

    Tadynn, Using what you already have: =(OFFSET(AB$9,-1,CONCATENATE(&quot;-&quot;,COUNTBLANK(A$9:AB$9)-1),1,1)) to get the sum, you just alter the formula to: =SUM((OFFSET(AB$9,-1,CONCATENATE(&quot;-&quot;,COUNTBLANK(A$9:AB$9)-1),1,1)):AB$8) then to divide by the number of blank cells...
  18. sfvb

    Forgot the link. http://www.tech

    Damn! Now we all have to try and figure out the incomplete link to find out what you were looking for. [sad] Steve
  19. sfvb

    Help me I.D. this font please.

    Looking at the choices given you so far: It's not Bookman Old Style - The C, t and S give it away. It's not Century - for the same reason (the C, t and S). I don't have Palatino Roman, but I do have Palatino Linotype. Both Book Antiqua and Palatino Linotype are extremely similiar. It looks...
  20. sfvb

    What are the leading web technologies?

    I've been seeing more and more JSP pages lately. Seems like this is starting to take off. Steve

Part and Inventory Search

Back
Top