All I'm trying to do is start with a range and then autofill based on a variable that the user enters for the number of tenants. For this part what I have now is this:
I recorded a macro to try and figure out autofill, but can't get that line to work. How do you put a variable in place of a fixed range?
Please Login or Register to view this content.
???
???Please Login or Register to view this content.
Last edited by mjr veverka; 04-07-2022 at 01:36 PM.
One way:
PHP Code:Sub AutofillNm()
Dim TenNum As Integer, startRng As Range
TenNum = InputBox("How many tenants")
Set startRng = Range("N12")
startRng.Offset(1, 0).Resize(TenNum - 1).Value = Range("N12").Value
End Sub
Quang PT
Another optionPlease Login or Register to view this content.
I don't know how to write "solved" on here, but I got it now. Appreciate everyone's help!
Glad to help & thanks for the feedback.
To mark as solved click on the "Thread Tools" button at the top of the thread & it should be in there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks