Locat a cell

G

Guest

Cool. But it would not inset the text part. When I removed it, it did work
adding the last row in.
Thanks


Cells(i, 1).Value = Cells(i, 1).Offset(-1, 0).Value & "
 
J

JW

It works on my end for insterting the text. Are you receiving an
error? The complete line should be:
Cells(i, 1).Value = Cells(i, 1).Offset(-1, 0).Value & "Total"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with vba 3
Remove Hyperlinks Without Changing background shading 14
CONDITIONAL FORMATTING IN VB 5
adding lines of code to a macro to delete rows 11
Apply Alternate Shading to selected rows 2
Match and Range Reference Syntax 3
Copying a Picture From Cell Comment 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top