ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selected cells not updating (https://www.excelbanter.com/excel-programming/392785-selected-cells-not-updating.html)

jinx

Selected cells not updating
 
Hi,

I have a Workbook (WB1) that is located on a web page. I am opening WB1 via
VB code into a new WB - WB2. a selection of the cells from WB1 are displayed
in WB2 via cell formulae.

The idea is the WB2 is auto updated when WB1 is updated.

I have added recalculate in the code.

the problem is that the data is not being updated in WB2.... does anyone
have any ideas why this may be happening (I'm sure it was ok, but seems to
haev stopped working!)

--
Thanks... Jinx


All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com