Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a list of numbers, starting in C2. The below snipit sends the cell
values to a webpage and the user selects the starting row to send out to the web page, usually C2, but could be any row in the list. Item # 1932 27029 27073 27382 28087 28227 29142 29195 29299 29302 29321 29488 29498 Snipit: For i = 0 To response SendKeys ActiveCell.Value SendKeys "{TAB}" Application.Wait (Now + TimeValue("0:00:01")) ActiveCell.Cells(2, 1).Select Next i "response" is determined by user (how many rows to send to web page, i.e., 10). Now, the problem is, even though the user selects the starting point, the above code selects the next cell down. I've even put "activecell.cells(0,1).select" and "activecell.cells(1,1).select" above the FOR statement. The "0,1" of course goes up to the "ITEM#" which failes on the search page on web and the "1,1" has no effect. Can anyone help? Thanks, Don |