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...
Type: Posts; User: swinnersmusic
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...
there is no NEXT following the FOR loop.
What is this code trying to achieve please?
Rajest:
also experiment with recording a macro.
here is one that has captured entering a formula and filling it across:
Sub enterformula()
'
' enterformula Macro
'
'
Rajest, try changing the code from:
Do Until Cells(myrow, mycol + 1).value
to
Do Until Cells(myrow, mycol + 1).Formula
Alan
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...
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...