Hi,
I want the user to select a textstring in a combobox that should be displayed in range("I2"). Somehow i get an error message. What am i doing wrong?
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by MaartenRo; 03-24-2021 at 02:45 AM.
First, Cells(9, 2) is B9, not I2. If you want to refer to I2 use one of these:
Cells(2, 9)
Cells(9, "I")
Range("I2")
When the error occurs, what line of code is highlighted when you enter Debug? What is the error message?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thank you for your comment on the cell reference.
The error occurs at:
How can i solve this problem?Please Login or Register to view this content.
Any input is much appreciated!
Last edited by 6StringJazzer; 03-24-2021 at 08:09 AM.
Thanks for your reply I solved it by copying the macro's to a new workbook. I guess it has something to do with security of the Excel sheet that i got from someone else.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks