Locat a cell

  • Thread starter Thread starter Guest
  • Start date Start date
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 & "
 
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"
 
Sorry, it did work. I had to clean up the work sheets. They go a little masy.
 
You must log in or register to reply here.

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
Copying a Picture From Cell Comment 0
adding lines of code to a macro to delete rows 11
CONDITIONAL FORMATTING IN VB 5
conditional format - table - cell empty return default color 1
Apply Alternate Shading to selected rows 2
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

Back
Top