home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 10,685 of 10,840   
   Stratocaster to All   
   Select Cells, and performing macro on se   
   05 Nov 08 00:18:29   
   
   From: stotz1@verizon.net   
      
   Hello, and thank you for any help in advance.   
      
   I need help determining if any commands exist in VB (Excel macro style) that   
   can enable a user to select cells and run a macro which performs operations   
   on those cells.  I am a beginner and am not sure if this is possible.   
      
   And if you'd really like to teach me a lesson. . . .   
      
   Could this be iterated with a while loop?   
   Suppose I wanted to simply make a graph of each row in a dataset and each   
   graph also contains the last line in the set (so two rows being graphed, one   
   fixed and one iterated).  Assuming I had 10 rows (labels in Row 1 and Column   
   1) I would want a seperate graph for each of the following pairs of rows:   
   {(2,10), (3,10), . . . (9,10)}.  Is this possible?  If so, would you offer   
   me any wisdom on how I could set this up?   
      
   Until this point, record macro has been my only reliable source of   
   information since I do not seem capable of looking up the magical command   
   statements in the help menu to enable these actions.  Again thank you for   
   any help or advice.   
      
   Thank you   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca