Use Cells(4, iPasteCol).address)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jewel Sharma Sent: Tuesday, October 08, 2013 1:08 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Writing a string to a particular cell Hi, This should have a quick fix hopefully. Please tell me what's is wrong with the following lines in the code: sStr1 = "Personnel " & iNumPer + 1 ThisWorkbook.Worksheets("Job Details").Range(Cells(4, iPasteCol)).Value = sStr1 When i run the code, I receive Run-time error '1004': Application-defined or object-defined error sStr1 is declared as a "string". iNumper is declared as an "Integer". iPasteCol is declared as an "Integer". I've used MsgBox to confirm the values stored in them are correct. Currently, iNumper = 1, sSTR1 = "Personnel 2", iPasteCol = 19. All I want to do is to write [Personnel 2] in cell S4 of the worksheet "Job Details"; but I need to use the column index number instead of the letter. I've tried Range.Text, as well as Range.FormulaR1C1; but I receive the same error. Thanks in advance. Jewel -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.