Search results for query: *

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...

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

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...

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...

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

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...

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

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 =...

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 =...

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

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

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...

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

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?

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

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...

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

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

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...

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...