Good morning
Thank you for reading my enquiry
I have script that starts from a static position and copies a list of companies who have submitted quotes et. Viz:
All worked fine until the third party system started to vary output to varies rows, for example "A9".
I cannot work through script that asks for the system to find the dynamic starting point for the company list copy, say to start from $A$9
Any guidance most welcome.
Mel
Thank you for reading my enquiry
I have script that starts from a static position and copies a list of companies who have submitted quotes et. Viz:
VBA Code:
'To copy current list of submitters for populating the charts and word master
Sheets("Data").Visible = True
Sheets("Data").Select
Range("A11:A11").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("Setup").Select
Range("B4").Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
All worked fine until the third party system started to vary output to varies rows, for example "A9".
I cannot work through script that asks for the system to find the dynamic starting point for the company list copy, say to start from $A$9
Any guidance most welcome.
Mel
Last edited by a moderator: