01-29-2010, 09:07 AM
Hi,
I've been looking for a way to add certain variables that i've extracted to a new row in Excel, however I cant find any way of doing this other than manually selecting the new row and then having my macro type the variables into the columns.
For example, I have 3 variables to add to a new row.
So if row 1 was clear in my Open excel sheet (Book1) I am tryin to add str a to A1, str b to B1 & str c to C1.
If row 1 already hd data, I would want to add it to the next blank row, e.g B1, B2 & B3.
Is there a way to do this without manually selecting the line to key them in?
Thanks,
Paul
I've been looking for a way to add certain variables that i've extracted to a new row in Excel, however I cant find any way of doing this other than manually selecting the new row and then having my macro type the variables into the columns.
For example, I have 3 variables to add to a new row.
So if row 1 was clear in my Open excel sheet (Book1) I am tryin to add str a to A1, str b to B1 & str c to C1.
If row 1 already hd data, I would want to add it to the next blank row, e.g B1, B2 & B3.
Is there a way to do this without manually selecting the line to key them in?
Thanks,
Paul