$$Excel-Macros$$ Array_concept

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

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

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

Re: $$Excel-Macros$$ Array_concept

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 rockerna...@gmail.com wrote: This Question is

Re: $$Excel-Macros$$ Array_concept

Hi Sam, Long Time Bro. Welcome Back...!! :) Regards Ashish On 13 December 2014 at 18:32, Sam Mathai Chacko samde...@gmail.com wrote: Mandeep, It's not like that. For that you'll need to understand how Transpose works. Try this first ;) ARR =

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

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

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

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 eugene.bern...@gmail.com wrote: Just like put a string

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

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,

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

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