79240629

Date: 2024-11-30 23:01:33
Score: 8.5 🚩
Natty:
Report link

Thanks for your suggestions. If I use .Formula it puts @ in front and if I use .Formula2 it produces a spill when I look in B330, believing it is an array. However, this is not what I want. It seems the only way I can get dynamic lables to work is to construct the formula in the actual cell B330 using: ="='"&C333&"'!G181:G"&TEXT(181+$B$176*2-1,0) and leaving calculations automatic on while I run the macro. Any thoughts ?

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Blacklisted phrase (1.5): Any thoughts
  • RegEx Blacklisted phrase (1): I want
  • No code block (0.5):
  • Ends in question mark (2):
  • Self-answer (0.5):
  • Single line (0.5):
  • Looks like a comment (1):
  • Low reputation (1):
Posted by: Gary