Feb 15 2023 09:35 AM
Hi all...
Hope some one help me with this issue as am stuck is this stage
Right now i have a worksheet that scrapping some stocks data from the internet called data
Another sheet called stkdata collect this data into a table for better use of it
Right now when using vba cell value change to copy it in another row and record the stock changes over time , the problem is the code is working good with the cell when maually input values but when automatically refresh and update stock date above internet the value is updates and the vpa is not notice the cell value is changed so its not recorded or past in other rows
How to make vpa notice change in cell value so it could record and copy the new value in a new row EVEN when this value comes from internet scraping and updated every time i make refresh
My code is
If Target.Address = Range("G5").Address Then
Dim LastRow
LastRow = Cells(Rows.Count, 2).End(xlUp).Row + 1
Range("G5:N5").Copy _
Destination:=Range("B" & LastRow & ":I" & LastRow)