itemPrice is a number that is inputted by the user. I want this number to be pasted on several columns (C to N) on a specific user inputted row. Running this gives me an application-defined or object-defined error due to "Range(Cells(theRow, C)).Value = itemPrice".
Please Login or Register to view this content.
juliorevka,
It looks like its because your code is referencing a variable C and a variable N instead of giving the Cells() statement the string values "C" and "N" for the column letters. Put quotation marks around "C" and "N"
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try:
DomPlease Login or Register to view this content.
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Adding a quotation marks made a different type of error appear, but Domski's code worked.
How exactly do the "&" signs within range work?
Last edited by juliorevka; 03-05-2012 at 12:24 PM.
They concatenate the various parts into a single string like Range("C2:N2")
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks