![]() |
Excel Help
I am trying to use this code to update my workbook, problem i have is when it updates it moves cells can some one add whats needed so the data is overwriten and no new cells added.
Code:
|
I have made some changes to the way i want to import webpages but need some help.
Below is the code i will use to import a web query but what i need to do is link it to a cell that will use a vlookup formula what i intend to do is in column A i will have a list of races in column B i will have a weblink to the races then in cell C1 i will have the vlookup formula i need the macro to run and return the contenst of the webpage in excel. I have looked at a few examples but and still not getting the result i need Code:
|
Ok i have worked out how to link it to a cell now i am trying to get it to work on a calculation event so it will run automatic.
Code:
|
Problem solved
|
All times are GMT +10. The time now is 01:58 AM. |
Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.