Search:

Type: Posts; User: rory; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.12 seconds.

  1. Replies
    8
    Views
    179

    I don't think you can do this with a simple...

    I don't think you can do this with a simple number format with centre alignment.
  2. Replies
    8
    Views
    179

    Format them as: 0_X;-0_X_X;0_X;@ and that...

    Format them as:
    0_X;-0_X_X;0_X;@
    and that should work for single digit numbers.
  3. Replies
    8
    Views
    179

    Unless you use a fixed width font, no placeholder...

    Unless you use a fixed width font, no placeholder will work since letters are shown in different widths.
  4. Replies
    5
    Views
    124

    Just bear in mind that if you use Option Explicit...

    Just bear in mind that if you use Option Explicit - and you should - that solution won't work since, as I said, Blank is just an undeclared variable and not an intrinsic VBA value. Of course you'll...
  5. You could use: With...

    You could use:

    With ActiveSheet.PivotTables(1).TableRange1
    .Resize(.Rows.Count - 1).Offset(1).Select
    End With
  6. Replies
    5
    Views
    124

    Or equally: If UserValue = fish Then Exit...

    Or equally:

    If UserValue = fish Then Exit Sub
    since Blank is just an undeclared variable in that code. ;)

    FWIW, you can distinguish between the user pressing Cancel or pressing OK with a...
  7. Replies
    8
    Views
    207

    That's not correct. While...Wend is perfectly...

    That's not correct. While...Wend is perfectly valid in VBA, if a little old-fashioned.
  8. Replies
    6
    Views
    176

    So column A and column B have the names of the...

    So column A and column B have the names of the ranges in, but are not themselves the named ranges?
  9. Replies
    6
    Views
    252

    You said you're using a macro to get the pictures...

    You said you're using a macro to get the pictures - what's the code? If it uses Pictures.Insert, that's the problem. You should use Shapes.Addpicture which allows you to specify whether to link or...
  10. Replies
    6
    Views
    176

    For instance: Sub Name_Range() Dim n As Long...

    For instance:

    Sub Name_Range()
    Dim n As Long
    For n = 1 To 10
    ThisWorkbook.Names.Add Name:=Worksheets("DEFSR").Range("B" & n), _
    RefersTo:=Worksheets("DEFSR").Range("C" & n)
    Next n

    End Sub
  11. Replies
    6
    Views
    252

    What settings do you have checked under 'Image...

    What settings do you have checked under 'Image size and Quality' in Excel Options - Advanced section?
  12. Replies
    22
    Views
    1,334

    [SOLVED] BTW, it's easier and faster to populate your...

    BTW, it's easier and faster to populate your listbox like this:

    AssetListBox.List = Sheets("sheet1").Range("A2:A141").Value
  13. Thread: New Lounge layout

    by rory
    Replies
    83
    Views
    2,235

    Sounds familiar. ;)

    Sounds familiar. ;)
  14. Thread: User Form Code

    by rory
    Replies
    2
    Views
    211

    Apart from a couple of typos (txtassetype control...

    Apart from a couple of typos (txtassetype control name) and an attempt to setfocus to a label, your code works. It does, however, skip row 2 because you have populated cells there already. I'm not...
  15. If you mean the 'Trust access to the VBA Project'...

    If you mean the 'Trust access to the VBA Project' option, you should have had an error if that wasn't checked, since you said that you didn't have an On Error Resume Next line in the real code.
  16. The file shouldn't be there after the code runs,...

    The file shouldn't be there after the code runs, since it deletes it after the import.
  17. You could use something like this: Private Sub...

    You could use something like this:

    Private Sub Worksheet_Calculate()
    Me.Tab.ColorIndex = Range("D16").DisplayFormat.Interior.ColorIndex
    End Sub

    which I don't think will clear the Undo...
  18. If you uncomment the On Error Resume Next line,...

    If you uncomment the On Error Resume Next line, what error do you get, if any?
  19. Replies
    4
    Views
    385

    Perhaps you have a timescale axis?

    Perhaps you have a timescale axis?
  20. You may also need to unprotect all the sheets...

    You may also need to unprotect all the sheets first, then change the style, then reprotect all the sheets.
  21. Replies
    4
    Views
    302

    Divide the 1039 by 24 to convert it to the...

    Divide the 1039 by 24 to convert it to the correct number of days (43.29 approx) and then subtract 39:45 from that number - not 39.45). Format the result as [h]:mm
  22. It's just: ...

    It's just:

    activeworkbook.Styles("Normal").Locked = false
  23. For example: ...

    For example:

    ActiveChart.ChartTitle.HorizontalAlignment = xlHAlignCenter
  24. Replies
    2
    Views
    138

    Do you mean: ...

    Do you mean:

    =LOOKUP(2,1/(Worksheet!$C$10:$C$22=$A7)/(Worksheet!$B$10:$B$22=B$6),Worksheet!$R$10:$R$22)
  25. Replies
    2
    Views
    713

    What is Outlook? If it's a variable, I'd suggest...

    What is Outlook? If it's a variable, I'd suggest using a different name. If not, you should be using an Object variable .
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4