Answer the question
In order to leave comments, you need to log in
How to insert arbitrary text before native text?
Hey!
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
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 questionAsk a Question
731 491 924 answers to any question