Output Text in specific place

[narutard]

this is pretty easy question but i was wondering how do you output a specific text in a specific place

the specific place will be determined by a variable that i previously defined, i.e. the end of a set number of rows. the set number of rows are variable each time, hence i need to use a variable

thanks

[Tom Ogilvy]

Cells(rwNum,"C").Value = "Some kind of text"

--
Regards,
tom Ogilvy

"narutard" <[email protected]> wrote in
message news:[email protected]...
>
> this is pretty easy question but i was wondering how do you output a
> specific text in a specific place
>
> the specific place will be determined by a variable that i previously
> defined, i.e. the end of a set number of rows. the set number of rows
> are variable each time, hence i need to use a variable
>
> thanks
>
>
> --
> narutard
> ------------------------------------------------------------------------
> narutard's Profile:
http://www.excelforum.com/member.php...o&userid=25111
> View this thread: http://www.excelforum.com/showthread...hreadid=386216
>

[STEVE BELL]

Worksheets("MySheet").Cells(rw,col).Text = "Text"
or
Worksheets("MySheet").Cells(rw,col).Text = str

where
Dim rw as Long, col as Long, str as String

--
steveB

Remove "AYN" from email to respond
"narutard" <[email protected]> wrote in
message news:[email protected]...
>
> this is pretty easy question but i was wondering how do you output a
> specific text in a specific place
>
> the specific place will be determined by a variable that i previously
> defined, i.e. the end of a set number of rows. the set number of rows
> are variable each time, hence i need to use a variable
>
> thanks
>
>
> --
> narutard
> ------------------------------------------------------------------------
> narutard's Profile:
> http://www.excelforum.com/member.php...o&userid=25111
> View this thread: http://www.excelforum.com/showthread...hreadid=386216
>

[Tom Ogilvy]

both of those raise errors since the TEXT property of a range is read only.

To the original poster, if you need to write on a sheet that is not the
active sheet, then you can qualify your reference with the worksheet name
(if you are writing to the activesheet, you can omit the worksheet
qualification or use ActiveSheet)

Dim rwNum as Long
rwNum = 21
worksheets("Sheet1").Cells(rwNum,"C").Value = "Some kind of text"

or
Dim rwNum as Long, colNum as Long
rwNum = 21
colNum = 3
worksheets("Sheet1").Cells(rwNum,colNum).Value = "Some kind of text"


The value can be a variable as well.
Dim rwNum as Long, colNum as Long
Dim sStr as String
rwNum = 21
colNum = 3
sStr = "Some kind of text"
worksheets("Sheet1").Cells(rwNum,colNum).Value = sStr

--
Regards,
Tom Ogilvy



"STEVE BELL" <[email protected]> wrote in message
news:w3AAe.39948$ZN6.971@trnddc02...
> Worksheets("MySheet").Cells(rw,col).Text = "Text"
> or
> Worksheets("MySheet").Cells(rw,col).Text = str
>
> where
> Dim rw as Long, col as Long, str as String
>
> --
> steveB
>
> Remove "AYN" from email to respond
> "narutard" <[email protected]> wrote
in
> message news:[email protected]...
> >
> > this is pretty easy question but i was wondering how do you output a
> > specific text in a specific place
> >
> > the specific place will be determined by a variable that i previously
> > defined, i.e. the end of a set number of rows. the set number of rows
> > are variable each time, hence i need to use a variable
> >
> > thanks
> >
> >
> > --
> > narutard
> > ------------------------------------------------------------------------
> > narutard's Profile:
> > http://www.excelforum.com/member.php...o&userid=25111
> > View this thread:
http://www.excelforum.com/showthread...hreadid=386216
> >
>
>