I found this code below in the internet, this one you can see that it can pick up range with its image, i tried using the technique below into the above code, but i failed. I appreciate your help.
...
Type: Posts; User: flora
I found this code below in the internet, this one you can see that it can pick up range with its image, i tried using the technique below into the above code, but i failed. I appreciate your help.
...
Dear Friends,
I have got this code below from this website which is a great piece of code form you gurus.
I need help with modification of this code. I want to add to each email the logo which...
Thank you DocAElstein
Thank you DocAElstein for your willingness to help. appreciated.
I downloaded the two files. when i run the macro. it only created two htm files and nothing into the word.
Hello,
I have a long word documents that has charts, tables, and paragraphs.
the charts, tables and some numbers in the paragraph comes from an excel file. but the process is very manual. like...
I have tried using =5* =6* =7* but it did not work.
snb thanks a lot
thank you kenneth
dear Administrator
thanks very much. the code is much faster and it works as i have excel 2016. it has one issue. the condition of product is missing. it ignores that. the condition on the...
I am very much interested to learn use of scripting dictionary in VBA and use of Arrays in VBA for Excel.
do you have any recommendation where should i start? blog, book, video tutorial.
thanks.
thank you very much Administrator.
this excelfox is really the best.
dear Administrator,
how can i change this code that instead of hard coded values of "|2001|2002|2003|2011|2012|2017|" i used cell reference
for example. my 2001 will be in cell A2 and 2002...
Thank you genius
to make it work. i added one extra vertical bracket If Instr(1,"|2001|2002|2003|2011|2012|2017|", "|" & ShD.Cells(C.Row, intYearCol).Value & "|") >0 Then
thanks alot
if this is the one to...
this is the sample workbook. original is more or less the same. if i can make this work, then i can update the original one as well.
thanks alot Administrator
WOW!
Admin you are amazing!
it works.
thanks so much
thanks very much for reply and willingness to help.
i replied to the other thread. pivot table is not an option.
thanks.
thanks very much for reply and willingness to help.
i replied to the other thread. pivot table is not an option.
thanks.
Thanks.
Yes, i am familiar with pivot tables. this code is part of a an application that my predecessor left. i would not use pivot tables.
thanks.
I have this code below,
now if i have to modify this, add more conditions. for example more years to include for example instead of many OR and AND functions, i simply want to use an array for...
Hi have the attached solution which works. but it is too slow.
i was wondering if there is a way to modify the code and use alternative options in VBA for example Scripting Dictionary to make...