Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lucille Holmes   on Aug 25 In MS Office Category.

  
Question Answered By: Ada Bailey   on Aug 25


Thank you for your suggestion, but in fact that doesn't fit the
grouping of the relevant cells. They are all contiguous, but not
surrounded by emply cells--so, in effect, it is only one part of a
larger block. In the present data  set, for example the entire block
would go from A1:N141, but the needed selection for the formulas is
E2:N141 . . . and the next set of data might have a different number
of rows, so I have a counter set up to check. I can get the correct
address for the block to show up in a MSG box, using the variables
from the counter, but I can't figure out the syntax to put that in
as a range to select for the fill down. There may be another way to
do this entirely, so I'm open to suggestions. Since I'm new to
Visual Basic, I might be overlooking something very simple.

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on I'm stuck . . . can you help, please? Or get search suggestion and latest updates.


Tagged: