$$Excel-Macros$$ Excel Macro to add rotated picture in Cell Comments

2014-12-13 Thread Zafar Iqbal
Dear Experts, I got a Excel macro to paste pictures in Excel cell comments. It is working fine. Now, I need a change in it. Pictures should be rotated 270 degree & then pasted in cell comments. Can anybody help, please? Thanks in advance. code is mentioned below:- Sub InsertPictures() Dim cll

Re: $$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

2014-12-13 Thread Ashish Kumar
Working Superb. WoW Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, lik

Re: $$Excel-Macros$$ Put Text Strings from Excel file to Outlook calander

2014-12-13 Thread Vaibhav Joshi
Hi Add a reference to the Microsoft Outlook Object Library (Tools > References... in the VBA editor) Check this.. + *I did not do this for you. God is here working through me for you.* On Fri, Dec 12, 2014 at 10:31 PM, Eugene Bernard wrote: > > Just like put a string inside a day box, for

Re: $$Excel-Macros$$ Date query for conditional format

2014-12-13 Thread Ashish Kumar
Hi Ashish, PFA Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Pl

Re: $$Excel-Macros$$ Array_concept

2014-12-13 Thread Ashish Kumar
Hi Sam, Long Time Bro. Welcome Back...!! :) Regards Ashish On 13 December 2014 at 18:32, Sam Mathai Chacko wrote: > Mandeep, > > > It's not like that. For that you'll need to understand how Transpose > works. Try this first ;) > > ARR = Application.Transpose(Range("A1:B1")) > > And

Re: $$Excel-Macros$$ Array_concept

2014-12-13 Thread Sam Mathai Chacko
Mandeep, It's not like that. For that you'll need to understand how Transpose works. Try this first ;) ARR = Application.Transpose(Range("A1:B1")) And ARR = Range("A1:B1") Regards, Sam On Sat, Dec 13, 2014 at 3:27 PM, Mandeep Baluja wrote: > > This Question is related to array befor

$$Excel-Macros$$ Date query for conditional format

2014-12-13 Thread Ashish Bhalara
Dear experts, I have series of date in which only sunday should be highlighted, please see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:R

$$Excel-Macros$$ Array_concept

2014-12-13 Thread Mandeep Baluja
This Question is related to array before answering please check my file and see what I want to Clear it's not a query it's a concept. I am trying to find out Arr = Application.Transpose(Range("A1:A10")) How array is considering this range whether in rows or in columns or whatever. MsgBox