hi,
I am new to vba. I want inputbox to ask a range and then input box ask formula which should be copied in the rang selected. I wrote a small code but it is not working. As i got struck in range itself , i never wrote input box for formula. your help will be great for me.
Please Login or Register to view this content.
Maybe lastrow should be a string
Or you may have to "set lastrow="Please Login or Register to view this content.
but then it would just be
`with lastrow`
But only for this formula (VLookup) ? Because it is unrealistic for everyone.
Since you can only select a cell in the active sheet, there would be no reason for any "with" statements
Please Login or Register to view this content.
try this
Please Login or Register to view this content.
Aanother clone:
Please Login or Register to view this content.
I am greatful to daboho and porucha vevrku. porucha vevrku was very useful and very detailed.
Mark as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks