Dear Users,
if I run the code below I get an alarm that the label is wrong and pointing to my "LagerplNEU" variable.
And I don´t know what the problem could be....
If I run with the lines which are now commented out it runs.. but my goal is to add to the value of that variable some signs like: copy LagerplNEU & "//" to .....
can somebody help me what is the problem?
Please Login or Register to view this content.
thank you indeed!
if I declare it as variant it works but I can not add some text to it.. can you help me?
the problem is in that line:
Please Login or Register to view this content.
Last edited by peterschein; 07-09-2019 at 02:28 AM.
Please be patient. Most people in the UK and Europe will not yet even be at work.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
of course I am
actually that doesnt work either:
Please Login or Register to view this content.
my guess, just get rid of "Set" key word from the last line.
Please Login or Register to view this content.
Dear Jindon
I tried what you mentioned but didnt work out...
this is the whole code:
the problem is in the marked row...Please Login or Register to view this content.
Last edited by peterschein; 07-09-2019 at 03:25 AM.
A String doesn't have a Copy method, but I don't see why you can't just use:
to assign the string to the cell.Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Try declare that variable as Range then....
Unfortunately non of them worked. I have the file attached and some explanation. the code is in MODULE "hinzufügen".
with the lines that are commented out it works I just need to add some string to it automatically what the user writes in AO20...
Just made two changes as suggested earlier and it's working fine for me with your below code.Originally Posted by peterschein
Changes:-Please Login or Register to view this content.
Removed Set keyword from signS = "/ /"
Defined LagerplNEU as range.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
"Set" key word should be used to set the reference to the OBJECT, and if you assign the value to the variable, "Let" key word and it can be omitted.
Please Login or Register to view this content.
Thank you jindon!
strangly I tried with let as well. I must have made some other mistake....
and dimming a combination of numbers and letters as range is new for me. I will have to read about that.
but cool, thank you all of you!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
You are welcome and thanks for the rep.
Yes, better study about variable types and your coding skill will get much better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks