Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    8
    Views
    3,961

    Not sure why I never brought closure to this...

    Not sure why I never brought closure to this issue. brettnewman is absolutely correct and I must have been unaware of the a action toolbar.

    Thanks to all for the help.
  2. Replies
    4
    Views
    694

    You might consider applying your 'psychic'...

    You might consider applying your 'psychic' energies to identifying significant number in his life. Most people choose numeric codes based on birth dates, combination of dates (like two children born...
  3. Replies
    4
    Views
    17,074

    Moz, would you mind sharing the macro for doing...

    Moz, would you mind sharing the macro for doing borders within a range? I have been struggling with something similar and a peek at your code would help.

    Thanks
  4. Replies
    0
    Views
    1,656

    Trying to do a facility project and need shapes...

    Trying to do a facility project and need shapes for toilet stalls in a public restroom. Thanks.

    Disregard - I found what I needed in the Building Core stencil.
  5. Replies
    8
    Views
    3,961

    1) The one line of code works well and I have it...

    1) The one line of code works well and I have it as a rotate macro... the other is just a fast toggle when I work with rectangular objects (shapes).

    2) I did the debug thing as you suggested and...
  6. Replies
    8
    Views
    3,961

    My problem with the macro not running was due to...

    My problem with the macro not running was due to the macro security setting within Visio. Once I changed that, the macro runs but not as expected.

    The macro is as follows:

    Sub Toggle_Shape()...
  7. Replies
    8
    Views
    3,961

    Thanks Andrew but when I put that code in...

    Thanks Andrew but when I put that code in (between the sub & end sub). It does nothing that I can see.
  8. Replies
    1
    Views
    427

    If your range is A1:C5 use this formula (replace...

    If your range is A1:C5 use this formula (replace the range accordingly)

    =COUNTIF(A1:C5,">0")
  9. Replies
    8
    Views
    3,961

    Want Visio macro to toggle shape angle

    I often will select a shape then go to the Size & Position box and change the angle from 0 to 90 or 90 to 0. This happens often enough that it seemed a good idea to have a macro to toggle the angle...
  10. Replies
    5
    Views
    1,146

    Got it. thank you.

    Got it. thank you.
  11. Replies
    5
    Views
    1,146

    Andrew - a question... In your code you have ...

    Andrew - a question...

    In your code you have


    If Target.Address = "$N$8" Then


    I am curious why the IF since the user has already said he wanted N8 to contain the sheet name. Also, how...
  12. Replies
    3
    Views
    788

    Just curious... if you did want to make it an...

    Just curious... if you did want to make it an add-in, how do you do that? and how would you share the add-in?
  13. Replies
    1
    Views
    2,474

    Here is a link for US Income tax forms in Excel....

    Here is a link for US Income tax forms in Excel.

    http://home.mchsi.com/~taxcalculator/

    I am looking for a similar Excel spreadsheet for the IRS form 1065 (Partnership return). Anyone have one?
  14. Replies
    11
    Views
    6,010

    Bruno, I used CDex from...

    Bruno, I used CDex from http://cdexos.sourceforge.net/?q=download and it worked fine. I also came across this that appears to be an even simpler solution although I have not yet tried it......
  15. Replies
    9
    Views
    1,647

    Thanks Sam - I love this and will certainly use...

    Thanks Sam - I love this and will certainly use it... often.
  16. Replies
    8
    Views
    1,021

    okay, I finally got it. Love it when the light...

    okay, I finally got it. Love it when the light comes on. Thank you.
  17. Replies
    14
    Views
    1,025

    Where can I learn more about how to use rngCell? ...

    Where can I learn more about how to use rngCell? The VBA help does not have anything about rngCell.
  18. Replies
    14
    Views
    1,025

    Thank you all for your help. There are, it...

    Thank you all for your help. There are, it seems, several ways to do what I needed. I looked in another resource and got yet another answer... see below.


    Sub Resetvalues()...
  19. Replies
    14
    Views
    1,025

    When I get that Object required error, the code...

    When I get that Object required error, the code that is highlighted is:

    For Each rngarea In myRange.Areas
  20. Replies
    14
    Views
    1,025

    I had already added that End With and now I have...

    I had already added that End With and now I have error that says Run-time Error '424':Object Required. the code in use now is:


    Sub Resetvalues()
    ActiveSheet.Unprotect
    Dim wsh As Worksheet
    ...
  21. Replies
    14
    Views
    1,025

    I had already added that End With and now I have...

    I had already added that End With and now I have error that says Run-time Error '424':Object Required. the code in use now is:

    Sub Resetvalues()
    ActiveSheet.Unprotect
    Dim wsh As Worksheet
    ...
  22. Replies
    14
    Views
    1,025

    I think it is getting closer although now I get a...

    I think it is getting closer although now I get a Compile Error: Expected End With
  23. Replies
    14
    Views
    1,025

    I must have deleted a post inadvertently - I am...

    I must have deleted a post inadvertently - I am still not quite used to this forum and the posting/editing procedures. I tried that code and kept getting errors... finally, I am using the following...
  24. Replies
    14
    Views
    1,025

    You read the post before I cleaned up some edits,...

    You read the post before I cleaned up some edits, see my revision.

    When you use a "For Each Item in Parent.Items" loop, you don't need the counter, see the VBA Help. (As an added bonus, VBA...
  25. Replies
    2
    Views
    461

    Yes, this does work now - it didn't before,...

    Yes, this does work now - it didn't before, though... I must have done something wrong. Thanks for the fast response.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4