I am trying to use VBA in excel to have the next empty cell value to be a combination of hard coded text and a variable.
The code below is part of a loop that goes through each of the worksheet and sets the variable userid to cell A1. I then want the code to enter the following in the next blank cell: INSERT INTO MF_SCTY_PRNC(USERID) VALUES ("<userid variable>");
I need to figure out what to set the value to..
Sheets("Scripts").Range("A" & lRow + 1).Value =
I know that I could set the 1st column to the text and then set the second column to the value but I was wondering if could be done in one statement because I wanted to expand on what the statement above is doing.
Thanks for the help in advance.
Matt
The code below is part of a loop that goes through each of the worksheet and sets the variable userid to cell A1. I then want the code to enter the following in the next blank cell: INSERT INTO MF_SCTY_PRNC(USERID) VALUES ("<userid variable>");
I need to figure out what to set the value to..
Sheets("Scripts").Range("A" & lRow + 1).Value =
I know that I could set the 1st column to the text and then set the second column to the value but I was wondering if could be done in one statement because I wanted to expand on what the statement above is doing.
Thanks for the help in advance.
Matt