Y
Y
Yuriy Berg2016-10-21 15:55:57
excel
Yuriy Berg, 2016-10-21 15:55:57

How to insert arbitrary text before native text?

Hey!
f9dd0d27d4894de0b918ee8000ae9398.png
There is such a column in front of which you need to insert the text images /
What would it look like images / text that is / ...

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Fedoryan, 2016-10-21
@AnnTHony

Formula for adjacent column:
Macro for the cells themselves:

Dim WB As Workbook
Dim WS As Worksheet
    
Set WB = Excel.ActiveWorkbook
Set WS = WB.ActiveSheet
    
' Вместо 5 указать действительное количество строк
For r = 1 To 5
    ' Вместо 1 указать номер ячейки, в которой нужно провести изменения
    WS.Cells(r, 1) = "images/" & WS.Cells(r, 1)
Next r

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question