Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Search For:

Type: Posts; User: Kieran

Page 1 of 3 1 2 3

Search For: Search took 0.09 seconds.

  1. Replies
    1
    Views
    2,987

    Re: Autofilter Hide Column

    Does the following help?


    Function AutoFilter_Criteria(Header As Range) As String
    'On Error GoTo em
    Dim strCri1 As String, strCri2 As String

    Application.Volatile

    ...
  2. Replies
    8
    Views
    3,166

    Re: Filterable Dynamic Chart Range

    cmorgan,
    Doesn't seem to be a way to do it. Refer to this.
  3. Replies
    8
    Views
    3,166

    Re: Filterable Dynamic Chart Range

    The no calculation in the chart series seems to be the case. But I am not 100% sure.

    You could however have the series refer to another named range that is the result of the calculation.
    See this...
  4. Replies
    4
    Views
    14,127

    Re: Scrambling Data In A Column

    In column B (or other vacant adajcent column) insert the formula =rand() .

    Then copy th formula down for the lenght of column A.
    Then sort by the new column of random numbers, and you will have...
  5. Re: String Search Function That Doesn't Return #value Error?

    Kadence,

    Try the following formula.

    =IF(ISERROR(SEARCH("z","word")),0,SEARCH("z","word") )
  6. Replies
    4
    Views
    1,028

    Re: MsgBox popping up on delete

    Brians12,
    It seems to me that the code is searching for a null/empty value after you delete a cell.
    The result of the find will then be the reult of looking for 'nothing' in wSht.Range("Data").
    ...
  7. Thread: Sounds in 2002

    by Kieran
    Replies
    3
    Views
    1,026

    Re: Sounds in 2002

    Oops,

    I should have been a bit more explicit.

    For any button 'CommandButton 1' the following code will cause a beep.


    Private Sub CommandButton1_Click()
    Beep
    End Sub
  8. Thread: Sounds in 2002

    by Kieran
    Replies
    3
    Views
    1,026

    Re: Sounds in 2002

    Try this

    Private Sub CommandButton1_Click()
    Beep
    End Sub
  9. Re: Array value seems to blow up to infinity possibly a memory overflow issue?

    U() defines an array, it can be of type Integer, or Long, or Double, or String or Variant.
    Defining it as a string may cause the formula to have problems. Try Long or Double or Variant. (Variant...
  10. Re: Array value seems to blow up to infinity possibly a memory overflow issue?

    Rick,

    Is there any reason why U() is defined as a string?

    I am think thing that U(x, y) = (U(x, y + 1) + U(x, y - 1) + U(x - 1, y) + U(x + 1, y)) / 4# may never be true if there is a rounding...
  11. Re: Loop through folder and print all files in folder

    Ladybug,

    I open the folder in explorer, select all the files and then choose print from the right click menu of the mouse.
    Note the pritn option only appears when all the files selected support...
  12. Replies
    3
    Views
    1,354

    Re: e-mail for every people only one row

    The code below is copied from the site and I think will do what you want.

    Sub TestFile()
    Dim OutApp As Outlook.Application
    Dim OutMail As Outlook.MailItem
    Dim cell As Range

    ...
  13. Replies
    3
    Views
    1,354

    Re: e-mail for every people only one row

    Try the tips at this site http://www.rondebruin.nl/sendmail.htm
  14. Replies
    3
    Views
    4,803

    Re: Date/Time Calculations in hours and tenths

    like this ?

    =INT(((A2+B2)-(A1+B1))*24) & " Hours " & ROUND(MOD(((A2+B2)-(A1+B1))*24,1),1) & " tenths"
  15. Replies
    4
    Views
    1,354

    Re: check box and change date

    Lisa,

    It is possible, but why nbot set up a recurring task in Outlok instead.
    That will achieve the same thing, and provide a much better reminder mechanism.
  16. Replies
    1
    Views
    3,432

    Re: Dynamic Array: Multidimensional

    try ...

    Public Sub realScen()

    Dim intPrice As Double
    Dim EBITDA As Double
    Dim ROR As Double
    Dim Price As Double
    Dim newprice As Double
    Dim...
  17. Thread: skip a step

    by Kieran
    Replies
    1
    Views
    925

    Re: skip a step

    Why not use

    For tiltAngle = 0 To 5*(Pi / 12) Step Pi / 12

    You will still get to the same steps, just the end value is 5/12s of PI, not 6/12's
  18. Re: i would like my line of code not to prompt for a Yes No...

    try

    ActiveWorkbook.Close SaveChanges:=False

    Note you will not save any changes
  19. Replies
    5
    Views
    1,525

    Re: Workbook closing

    Without a name - how do you identify it?

    You could use Workbooks(index), but means that you must know the index number of the workbook, not it's name. Is that the case?
  20. Replies
    5
    Views
    1,525

    Re: Workbook closing

    Try Activeworkbook.close

    If you do not want to save any cahnges or have any intervening prompts then use

    Activeworkbook.close SaveChanges:=False
  21. Replies
    6
    Views
    1,762

    Re: Valid Function - better idea?

    CallMeDJ,

    I received an error if I have the sheetname in mixed case, and the macro has it in upper case.

    Try changing
    With Sheets("DATA " & i)
    to
    With Sheets("Data " & i)
  22. Replies
    3
    Views
    1,196

    Re: Add numbers within a cell

    maa564,

    look at Bob Umlas under the heading Calculating The Sum Of The Digits.
  23. Replies
    1
    Views
    1,627

    Re: Multipage OptionButton Control

    If you make any selection on the first page, you should disable the options on teh second page and vice versa.

    This si what option button group do by default when enclosed in a group frame. Moving...
  24. Re: Excel VBA - Array help (convert code to an array)

    bremen,

    this is untested, but it may give you a start


    Sub CopyRoster()

    Dim SrcRng(5) As Range
    Dim DestRng(5) As Range
    Dim s As Integer
  25. Replies
    2
    Views
    1,128

    Re: Simple chart showing years only on axis

    Have you tried adding 1994 to the year column on the worksheet.

    If that does not work, post the workbook here. It is very difficult to understand the problem without more information.
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno