ckelley1020
02-22-2011, 08:36 PM
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
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