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 derfloh 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: osx99
  • Order by date
  1. osx99

    Protect worksheets, but allow resizing of rows and columns

    makeitwork09 - sorry do destroy your thread... Skip, I've appreciated many of your posts and you do know what your talking about but your becoming too long in tooth and negative with your posts! I appreciate people have to learn but there are many reasons for needing many obscure functions that...
  2. osx99

    Protect worksheets, but allow resizing of rows and columns

    I misread your post as 'You can only do this in VBA', which is not what you wrote. Sincere apologies!
  3. osx99

    Protect worksheets, but allow resizing of rows and columns

    Sorry Skipvought, but if your protecting your OWN sheet you don't need VBA. Set the required protection options as I mentioned above. If you are using Excel 2003 then perhaps you're right but in Excel 2007 & 2010 you can protect the cell contents but allow for inserting of rows/columns and...
  4. osx99

    Protect worksheets, but allow resizing of rows and columns

    There should be an option in Excel 2007 that allows a user to 'Protect sheet' With the options available select 'Format Columns' & 'Format Rows' this allows the cell contents to be locked but the sizing to be amended. I'm using Excel 2010 but I know for a fact this can be done in Excel 2007...
  5. osx99

    Screen animation capture software

    I'm unsure about PowerPoint capability so someone else could probably help. However, this is a really good free tool that allows you to record your screen and playback with a very small filesize. http://www.bbsoftware.co.uk/BBFlashBack_FreePlayer.aspx
  6. osx99

    User input variables not passing values to new procedure in Excel VBA

    If your psychic you can pick some numbers for me too :) Andrzejek has given by far the best advice on this thread - understand the scope of your variables. My example works but only gives a few possible examples. Also note that: Dim message6, title6, default6 is different to Dim message6...
  7. osx99

    Display active workbook in E-mail but do NOT send

    This link should help http://msdn.microsoft.com/en-us/library/ff458119(office.11).aspx Change the .Send to .Display as mentioned in the comments
  8. osx99

    User input variables not passing values to new procedure in Excel VBA

    either define your variable as Public outside the procedure eg Public day As String Sub test() Dim message6, title6, default6 message6 = "Please enter the day you are reporting on in the format of ddd (e.g. Monday would be Mon)" title6 = "Inputbox" default6 = "Mon" day =...
  9. osx99

    Excel VBA formula using a changing cell 's value and a constant

    Also if cell .Range("S" & iRow) is empty then you will only have half a formula and will throw the Application error. One of many possible ways around it could be If IsEmpty(.Range("S" & irow).Value) Then .Range("H" & irow).Formula = "=G" & irow & "-" & "0" Else .Range("H" & irow).Formula =...
  10. osx99

    Excel 2007--where's my file located?

    Another method is to enter =CELL("filename", A1) into any cell
  11. osx99

    Excel - get result from range

    Having already posted I think the Excel 2010 method may also work in Excel 2007, Sorry!
  12. osx99

    Excel - get result from range

    There are a few options Excel 2003/2007 either [F1] = IF(ISERROR(VLOOKUP(E1,$A$1:$B$4,2,FALSE)),"",VLOOKUP(E1,$A$1:$B$4,2,FALSE)) or [F1] = IF(ISERROR(MATCH(E1,$A$1:$A$4,0)),"",INDEX($B$1:$B$4,MATCH(E1,$A$1:$A$4,0),1)) Excel 2010 either [F1] =IFERROR(VLOOKUP(E1,$A$1:$B$4,2,FALSE),"") or...
  13. osx99

    Excel macro

    or possibly use a UDF in a MODULE enter Function textSplit(ByVal text As String) Dim i() As String i = Split(text, "/") textSplit = "/" & i(UBound(i)) End Function Then use =textsplit(cell) in Excel. Eg if "/1/0/105.jpg" is in cell A1 then =textsplit(A1) returns /105.jpg
  14. osx99

    Filesystem object not defined

    Is it possible to add the required references from within VBA code? If yes, what syntax is required to load say the Microsoft Scripting Runtime which I think is scrrun.dll?
  15. osx99

    Maths Formula Help

    It's in Excel but all is ok now thanks to jges. Thank you
  16. osx99

    Maths Formula Help

    I'm unsure which is the most appropriate forum for this question so thave opted for the here I have a formula... S * [a ^n(1-X)] * [b ^nX] = S Can someone help me with the steps to get X = ? I have given this a few tries and can get to a^n = b^(-nX) - a^(-nX) but am struggling to get any...
  17. osx99

    Excel Formula Help

    Thought as much. UDF it is then. Thanks Combo!
  18. osx99

    Excel Formula Help

    Sorry above post should be amended to read Eg A100 = 1000 A101 =A100+Round(A100*0.12,2) . . A120 =A119+Round(A119*0.12,2) = 9646.31
  19. osx99

    Excel Formula Help

    I have a formula in excel which works out a compound interest X = P*(1+R)^N or as excel formula =B3*(1+B4)^B5 Where P = starting amount, eg 1000.00 R = rate, eg 0.12 N = number of iterations, eg 20.00 In the example above the answer is 9646.29 rounded to 2dp What I need is to introduce a...
  20. osx99

    Redim Array Inner Bound?

    This is actually more representative of what I'm attempting to code. I just can't get this line to work Range("A16:E20").Value = chart_data(1) Private Sub test() Dim tempchart_data(1 To 5) As Variant Dim chart_data(1 To 5) As OsArray Dim a As Integer, b As Integer Dim chartdata_bound As...

Part and Inventory Search

Back
Top