Dear Pros,
how would you solve the issue in the attachment with arrays?
IŽd like to make a text or value compare in column E. And if there is a match I would like to increase the value next to it by 10
and print the value in column F...
thank you for your help!
Last edited by peterschein; 02-16-2020 at 05:00 PM.
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Originally Posted by peterschein
Do you mean "array variables" by writing "array", or just a certain area of the sheet in the form of a table/range/array ?
This can be done without array variables ...
I would like to fill up the array with the values and then print out the results.
I think it's called the array variable. like with dynamic lbound and ubound...
thanks for the help!
Is anything (below) an "array" for you ?
Please Login or Register to view this content.
Last edited by mjr veverka; 02-17-2020 at 09:10 PM.
wow thanks a lot porucha vevrku!
yes I ment the last one!
thank you a lot!
I often hear that working with arrays like your third solution is the best way because it is faster..but for me your second solution is so much easier...
I would still have one question: what exactly does your last line? and how?
I see that if I comment it out all the values are the first value (138).
thank you for your kind help!!
??? "Last line ... in the third macro" ???
Please Login or Register to view this content.
This is the end of Sub procedure
Or maybe this (?)
(?)Please Login or Register to view this content.
"Starting from cell 'D1', in an area of size adapted to the number of "rows" (first dimension) and "columns" (second dimension) in the variable 'arr', enter the content of this variable, and then delete contents of this variable (arr = Empty)""
thank you for your help and time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks