Passing rows to VBA and populate the results in another cell and set interval to refresh

**grcshekar** · 08-23-2023, 04:48 AM

Hi

In the enclosed sample, I have a VBA Code.
Sheet: Dashboard

1. I will have to pass rows starting from A5 and populate the result of VBA in F5 similarly for all the rows till A14
2. I also need VBA to run every 15 seconds without freezing the excel to refresh the results in Column E

**grcshekar** · 08-25-2023, 11:11 AM

I managed to write the VBA and getting the data,
However I would like to simplify the VBA in Module 1 and also sometimes the data in E comes blank due to blank value from HTTP which actually does not have null value on the web page
Can I get help on this please

Passing rows to VBA and populate the results in another cell and set interval to refresh

LinkBack

Thread Tools

Rate This Thread

Display

Passing rows to VBA and populate the results in another cell and set interval to refresh

Re: Passing rows to VBA and populate the results in another cell and set interval to refre

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Schedule refresh data at set interval

How to refresh sheet and keep results of a cell that keeps changing?

How to refresh sheet and keep results of a cell that keeps changing

[SOLVED] Repeat value from cell: X times with interval of Y rows

[SOLVED] Populate data according to interval

Passing cell address into ROWS formula

Refresh cells after a particular time interval and copy into another file :)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions