Worksheet_Calculate
Hi Howard,
Am Sat, 6 Aug 2016 22:20:45 -0700 (PDT) schrieb L. Howard:
Range("B8:B37")) are formulas returning strings such as "Cash" or Equities", as two examples, then data is copied to a certain sheet for that string. There are about thirteen different sheets/strings.
This Select Case fails because Target is the entire range of B8:B37.
How do I zero in on the cell that just calculated to make my data transfer correctly?
I have to assume that any of the strings will appear more than once within the B8:B37 cell range. So if a calculate event occurs and returns "Cash" to a cell, there may be one or more strings "Cash" already in the range. I only want the cell that just recalculated.
please post the formula for that range.
Regards
Claus B.
--
Windows10
Office 2016
|