I'm tying to write a macro program for an Excel file but I dont know how to make "Ox" instead of "O3" !Sub Macro1()'' Macro1 Macro'' Keyboard Shortcut: Ctrl+o'l = 50For x = 1 To l Range("O3").Select Selection.Copy Range("A3").Select ActiveSheet.Paste Next xEnd Sub. Created by -#-Romin-#-. computers-internet-en - programming-design-en

Range("O" & x + 2).SelectorCells(x+2,15).select

VB Problem : How to write a variable inside a character?

May 2021 1 96 Report

VB Problem : How to write a variable inside a character?

I'm tying to write a macro program for an Excel file but I dont know how to make "Ox" instead of "O3" !

Sub Macro1()

' Macro1 Macro

' Keyboard Shortcut: Ctrl+o

l = 50

For x = 1 To l

Range("O3").Select

Selection.Copy

Range("A3").Select

ActiveSheet.Paste

Next x

End Sub

Computers & Internet / Programming & Design

ungkog

Range("O" & x + 2).Select

Cells(x+2,15).select

0 votes Thanks 0