Hello Friends,
I need some help to add some variables in loop of below code. Location is mentioned in code.
This is picked from http://www.rondebruin.nl/win/s1/outlook/amail6.htm
ThanksPlease Login or Register to view this content.
Liz
Hello Friends,
I need some help to add some variables in loop of below code. Location is mentioned in code.
This is picked from http://www.rondebruin.nl/win/s1/outlook/amail6.htm
ThanksPlease Login or Register to view this content.
Liz
Last edited by Liz_Biz; 05-07-2014 at 10:54 AM.
cell.offset(0,cols)
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hi nathansav,
Thank you so much for looking into this!!
Where I need to incert this? Could you help to get changes please?
Thanks,
Liz
.bcc = cell.offset(0,1) will get the column one across to the right.
No Luck.
This is no working. I am using below code.
Thanks,Please Login or Register to view this content.
Liz
cell.offset(y,x).value your cc is the same as your to they way above, is this correct?
nope. Cc is another column.
well you need to change the offset from (0,0) then. Offset is move down y and move across x, so you are not moving.
can you attach a sample, make it easier.
Its done!! Thank you so much for great and so quick help.
Liz..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks