Hi
Is there a way to loop this? The only thing changing is the range and only the letters change alphabetically.
ThanksPlease Login or Register to view this content.
Hi
Is there a way to loop this? The only thing changing is the range and only the letters change alphabetically.
ThanksPlease Login or Register to view this content.
Hi emjay,
Instead of using Range("F4") and Range("G17") use instead the Cells(RowNum, ColNum) format
Then something like
For ColNum = 6 to columns("AZ").column Step = 2
..
IE.document.All("itemCodeTextField").Value = ThisWorkbook.Sheets("Inventory Outlook").Cells(4,ColNum)
IE.document.All("quantityTextField").Select
IE.document.All("quantityTextField").Value = ThisWorkbook.Sheets("Order Sheet").Cells(17,ColNum +1)
...
Next ColNum
I hope that makes sense. If not keep asking.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks