Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    8
    Views
    179

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

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

    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?
  3. Replies
    6
    Views
    196

    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...
  4. Replies
    6
    Views
    141

    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
  5. Replies
    6
    Views
    196

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

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

    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
  7. Thread: New Lounge layout

    by rory
    Replies
    83
    Views
    2,000

    Sounds familiar. ;)

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

    by rory
    Replies
    2
    Views
    179

    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...
  9. 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.
  10. 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.
  11. 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...
  12. 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?
  13. Replies
    4
    Views
    351

    Perhaps you have a timescale axis?

    Perhaps you have a timescale axis?
  14. 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.
  15. Replies
    4
    Views
    277

    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
  16. It's just: ...

    It's just:

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

    For example:

    ActiveChart.ChartTitle.HorizontalAlignment = xlHAlignCenter
  18. Replies
    2
    Views
    124

    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)
  19. Replies
    2
    Views
    653

    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 .
  20. Replies
    6
    Views
    425

    Yes it would - because you're using a month...

    Yes it would - because you're using a month number, not name. You can include the space in the initial string directly:

    Sub UpdateHeader()
    ActiveSheet.PageSetup.RightHeader = "&""Arial,Bold""&12...
  21. Replies
    6
    Views
    425

    Sub UpdateHeader()...

    Sub UpdateHeader()
    ActiveSheet.PageSetup.RightHeader = "&""Arial,Bold""&12" & Range("y2").Text
    End Sub
    for example, for 12 point bold Arial.
  22. Replies
    2
    Views
    282

    No, it isn't, I'm afraid. You could always create...

    No, it isn't, I'm afraid. You could always create a separate table from your original that sorts the data and base the chart on that.
  23. It sounds as though you named your module Test as...

    It sounds as though you named your module Test as well, in which case use Test.Test while calling the routine or, better still, change the name of one of them!
  24. Replies
    3
    Views
    2,218

    If it is ActiveX: ...

    If it is ActiveX:

    Currsheet.oleobjects("OptionButton1").object.value = true
    should do the trick.
  25. Replies
    6
    Views
    425

    It's impossible to tell from that picture what...

    It's impossible to tell from that picture what the range reference in the dialog is, but I would not expect to see the path there if you have the file open.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4