How to Add a String to the beginning of every value in a range

**xladept** · 03-05-2018, 02:14 PM

This works:

Set InvoiceNameRng = _
ThisWorkbook.Worksheets("Sage Import").Range("B2:B" & Range("B2").End(xlDown).Row)

**tvxl** · 03-05-2018, 03:29 PM

Originally Posted by xladept

This works:

Set InvoiceNameRng = _
ThisWorkbook.Worksheets("Sage Import").Range("B2:B" & Range("B2").End(xlDown).Row)

Oddly enough it works within it's own sub. However, when I next it within the rest of my sub, it halts at row 19 on every page that I try it with. Any idea why that might be?

How to Add a String to the beginning of every value in a range

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: How to Add a String to the beginning of every value in a range

Re: How to Add a String to the beginning of every value in a range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Add a string between beginning and and of a chain per corresponding code

[SOLVED] How to delete the digits and the following spaces in the beginning of a string

Move Text From End Of String To Beginning

Excel 2007 : Add something to the beginning and end of the string

Add last word from a string to the beginning of new string

Add a string at the beginning and end

Is there away to add a zero to the beginning of number string?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions