Is it possible to update a range with both a prefix and the array?

[kcarley]

Okay! I've made my introduction and now here is my very first post. Excited? Yeah, thought so. Me too...

I'm working with a large volume of data and maybe I just need to go about it a different way but in addition to passing the array itself to the range, I'd like to prefix each cell with a single quote.

I'm using the basic Array to range logic but I can't seem to visualize putting the quote in without a loop. Any ideas?

Please Login or Register  to view this content.

Thanks in advance.

[kcarley]

Bump no response

I'm thinking the answer is 'no' but I'm holding out hope.

[kcarley]

Bump no response

[watersev]

hi kcarley, looks strange: to put ' sign in front ....

Enter values in A1:C3, run code:

Please Login or Register  to view this content.

[jindon]

Try change to

Please Login or Register  to view this content.

[kcarley]

Thanks guys!!

looks strange: to put ' sign in front ....

I actually agree with this... the more I've thought about it the harder is is to remember the exact reason but I will have to work on this tomorrow so maybe I can update you and me with the 'why' on this.

Really do appreciate the help!

Cheers,
K