Posts by Anicesio Junior • 21 points
3 posts
-
1
votes1
answer620
viewsQ: VBA how to find the specific name of a spreadsheet and impute data in it
Staff I have a list in plan("Register"). range("H2:H10") I have Data in the plan("Treaty"). range("A2":"Q1862") I want to search the name in the list of plan("Register"). range("H2:H10"), in…
vbaasked Anicesio Junior 21 -
1
votes1
answer725
viewsA: VBA Rowsource with variable
I decided to change the code especially the type of the variable plan As Worksheet to string and worked, as follows: Private Sub UserForm_Initialize() Dim plan As String Dim lin As Range Dim fim As…
vbaanswered Anicesio Junior 21 -
0
votes1
answer725
viewsQ: VBA Rowsource with variable
How do I place a variable spreadsheet in a Rowsource? I’m trying to concatenate with the last line but this giving error: Private Sub UserForm_Initialize() Dim plan As Worksheet Dim lin As Range Dim…
vbaasked Anicesio Junior 21