Search:

Type: Posts; User: swinnersmusic

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    10,335

    Thanks, Rick: Great use of "arrays" and because...

    Thanks, Rick:
    Great use of "arrays" and because your program addresses all shapes, here are a couple of trivial additions:
    Could use a star shape from the shapes toolbox for the tree-top star and...
  2. Replies
    3
    Views
    1,142

    there is no NEXT following the FOR loop. What is...

    there is no NEXT following the FOR loop.
    What is this code trying to achieve please?
  3. Rajest: also experiment with recording a macro....

    Rajest:
    also experiment with recording a macro.
    here is one that has captured entering a formula and filling it across:

    Sub enterformula()
    '
    ' enterformula Macro
    '

    '
  4. Rajest, try changing the code from: Do Until...

    Rajest, try changing the code from:

    Do Until Cells(myrow, mycol + 1).value
    to

    Do Until Cells(myrow, mycol + 1).Formula
    Alan
  5. solution to....filling across columns using VBA until blank cell is found

    Hello Rajesh:
    Step one:.....add a new module in the VBA environment
    Step two.....paste in the subroutine below which will be effectively a macro called "fillacross"


    Sub fillacross()
    Dim...
  6. macro text

    Hello:
    I got this code below when I recorded a macro while filling the chart area with a userpic of Paris Hotel
    The chart was embedded in the sheet.
    Its basically performing a Format Chart...
Results 1 to 6 of 6