Re: $$Excel-Macros$$ Re:

is there some other way to get the result. i do not know how to operate macros. if it cannot be done apart from using macros then please let me know how i can operate this particular macro in my computer in excel. the data which i have sent was just an extract. i need the data in the desired format

Re: $$Excel-Macros$$ Email Validation Micro

Thanks your replay, But I have solve this problem Thanks again On Tue, Nov 19, 2013 at 12:07 AM, ashish koul wrote: > how will u verify what are the conditions > > > On Wed, Nov 13, 2013 at 10:57 AM, Rupesh Patil > wrote: > >> Hi Experts, >> >> I am writing email validation micro, also i shar

Re: $$Excel-Macros$$ Formula to fetch employee names based on time

Dear Kartik, Thanks for your reply. All I want is when I select the timezone and the day, the employees working through the day would appear along with times. Let me know if any further clarification is needed. Regards...Abhishek On Mon, Nov 18, 2013 at 5:27 PM, Kartik Dale wrote: > Hi Abhi

Re: $$Excel-Macros$$ Date format_Not in Proper

Sir thanks for reply. But sir... For Only few rows not get corrected.. Rest things are perfects...why this so. Regard, Prafull Jadhav. 9920553518 On 19-Nov-2013 12:03 AM, "ashish koul" wrote: > is it 1 apr 2013 > > try to change the setting of ur computer control panel - regional setting > -

Re: $$Excel-Macros$$ Reverse an Array

Sub abc() Dim MyArray(3) As Integer MyArray(1) = 1 MyArray(2) = 2 MyArray(3) = 3 MsgBox MyArray(1) & MyArray(2) & MyArray(3) Z = MyArray(3) MyArray(3) = MyArray(1) MyArray(1) = Z MsgBox MyArray(1) & MyArray(2) & MyArray(3) End Sub see if it wrks On Wed, Nov 13, 2013 at 10:28 AM, Pavan Vallu

Re: $$Excel-Macros$$ Email Validation Micro

how will u verify what are the conditions On Wed, Nov 13, 2013 at 10:57 AM, Rupesh Patil wrote: > Hi Experts, > > I am writing email validation micro, also i sharing my code with you, can > any buddy tell where I am going wrong. I have to call this funtion on text > box Exit event > > code is >

Re: $$Excel-Macros$$ Date format_Not in Proper

is it 1 apr 2013 try to change the setting of ur computer control panel - regional setting - choose English USA then try the macro Regards Ashish On Mon, Nov 18, 2013 at 1:18 PM, Prafull Jadhav wrote: > DEAR RAJAN SIR, > > thanks for reply... > but output showing jan and feb month also afte

Re: $$Excel-Macros$$ Stuck in attaching multiple image files in email body

try something like this Sub sample_macro() Dim objOL As Object Dim olMail As Object Dim bdy As String For Each itm In Array("C:\Users\Public\Pictures\Sample Pictures\desert.jpg", "C:\Users\Public\Pictures\Sample Pictures\tulips.jpg") bdy = bdy & " " Next itm

Re: $$Excel-Macros$$ Address of Shapes

Sub test() Dim shp As Shape For Each shp In ActiveSheet.Shapes MsgBox Cells(shp.TopLeftCell.Row, shp.TopLeftCell.Column).Address Next End Sub On Mon, Nov 18, 2013 at 1:38 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Is there anyway to get cell reference of shap

$$Excel-Macros$$ VBA Tips - Learn the name of the Windows user

VBA Tips - Learn the name of the Windows user: https://groups.google.com/forum/#!topic/excelvbamacros/-pvfIVv7cp4 -- 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

Re: $$Excel-Macros$$ Wants to do repeated steps of Macro till last column

i have just add loop Sub rr() For i = 3 To 78 Cells(4, i).Select Selection.Delete Shift:=xlUp Cells(4, i).Select Range(Selection, Selection.End(xlDown)).Select Range(Cells(3, i), Cells(2028, i)).RemoveDuplicates Columns:=1, Header:=xlYes Next End Sub . Enjoy Team

Re: $$Excel-Macros$$ Formula to fetch employee names based on time

Hi Abhishek, Can you please be more clear on your request, so that we can try to solve your query Regards, Kartik On Wed, Nov 13, 2013 at 10:16 AM, Abhishek Jain wrote: > Friends, > > > I have a file, wherein I have times when employees are scheduled to > work. These times are in PST. > > I ha

Re: $$Excel-Macros$$ Help needed

Ravinder, PFA, Regards, Cartik On Tue, Nov 12, 2013 at 10:50 AM, Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi > > Please help me, to create a formula with small function and Vlook up > function. > > > Regards > Ravindra > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ Re:

Dear Sharad, the result is obtained through the macro. The macro does exactly what you would do manually adds an "enter" after each gluing one item from each column in the spreadsheet sub_ledger. Basole Em sábado, 16 de novembro de 2013 11h09min57s UTC-2, sharad escreveu: > > The attach file

$$Excel-Macros$$ Re: [XL-VBA Clinic] Date format_Not in Proper

Dear Sir, It is not working . Regards, Prafull Jadhav 9920553518 On Mon, Nov 18, 2013 at 3:40 PM, saurabh kumar wrote: > Hi Prafull, > > Please find attached & Check > > Regards > Saurabh > > > On Mon, Nov 18, 2013 at 1:11 PM, Prafull Jadhav > wrote: > >> Hi Sir, >> >> Thanks for Reply.. >> >

$$Excel-Macros$$ Wants to do repeated steps of Macro till last column

Dear All, Please Help.. I have just recorded a Macro & wants to do repeated steps in each columns starting from C to BZ. I have done pasting of few raws 2 more times.. but that will take long time to reach to last column.. do we have any shortcut or formula or Loop command... Range("C4").Sele

$$Excel-Macros$$ Address of Shapes

Hello, Is there anyway to get cell reference of shapes please find sampe excel. Thanks in advance. Regards, Chandru -- 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/discuss