Search the Community
Showing results for tags 'repeat till blank value'.
HI All, I've two questions to ask fromthe forum. 1) Firstly i've put some values in Column A of an Excel sheet. I want the macro to read each value till the time it finds a blank cell. The macro should pop-up an error message "There are no more values available". I've tried doing this but the macro is reading all the values including blank values. I've tried Repeat until and Repeat Start both options but failed to get the desired results. 2) Secondly Can i store an image in a variable in ME pro. I've a project in which i need to draft a template as per user selection and there should a particular logo depending upon the option selected on the top of the word document. Is it really possible ? Thanks in advance, Gagan