Solved: goto a specific cell and insert text using vb

[ckelley1020]

i need to go to a specfic cell using a position I have grabbed using

lastrow = ActiveSheet.UsedRange.Row - 1 + ActiveSheet.UsedRange.Rows.Count

totaltext = lastrow + 2

I need to put TEXT in that cell in column G. then put a formula (=count(H1:Htotaltext) in the next cell over in column H

how do I do that in VBA in excel? any help is appreciated

[shrivallabha]

Welcome to VBAX.
To use formula:=
[VBA]Range("G" & Totaltext).Formula = "=COUNT(H1:H" & TotalText & ")"[/VBA]
There is another method documented in VBA as FormulaR1C1 which uses column and rows' number reference. You may look into it, if you want to.

[ckelley1020]

Thanks for the help. How do I place text such as "Totals" in the specific cell G:totaltext. Thanks for the one for the formula in the example you sent.

[shrivallabha]

You need to tell VBA that the item being inserted is value. Like:
[VBA]Range("G" & Totaltext).Value = "Total"[/VBA]
Be sure that you cover text with double quotes.

[ckelley1020]

works great. thanks for the help