View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon[_2_] Simon[_2_] is offline
external usenet poster
 
Posts: 89
Default Range("E8:E53").FillRight how can I make this .Value?

Column E contains Vlookups.

I wish to open the workbook (and automatic update without needing to
click the update linked sheets if possible?) and fill right to fill in
the latest months data.

Yet I want to then remove the Vlookup expression so the users don't
know where it came from.

Any suggestions/thoughts, appreciated