i have a simple task that i wnat to automate.
i need to enter data in a certain sequence:
enter yyyy
move right
enter mm
move right
enter dd
move right
move right
enter a number as text
move right
enter a string
move right
enter a string
move right
enter a number as double
move right
enter a number as double
move right
move down one row
move to the beginning column and start all over again util control-
break
I can do most of the looping and error chcking thing, but believe it
or not i do not know how to get the entered data into the cell like
cells(iCurCol,iCurRow).value = [entered data]
how do i put the entered data into the value.
Thanks for any hint. I know it got to be something stupid or so
simple that i can see it.