How to use "CONCATENATE" function in VBA

  • Thread starter Thread starter mar_male
  • Start date Start date
M

mar_male

Hello
How can I do something like this I want to add to all cells in range
Range("A:A").SpecialCells(xlCellTypeConstants) a prefix string like UT_
for example. I know there is a "character" but how i can use it for ma
Range
____A_____B____
1 | UT_string | |
2 | UT_string | |
3 | UT_string | |
4 | UT_string | |
...........................
40| UT_string | |
41| | |
Thanks for response
 
Looks as though you're using Excel. If that's the case, you'd be better off
asking in a newsgroup related to Excel.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.
 
Back
Top