$$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 @

$$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).Select

$$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 saurabhkumar8...@gmail.comwrote: Hi Prafull, Please find attached Check Regards Saurabh On Mon, Nov 18, 2013 at 1:11 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:

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 do you

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 abhishek@gmail.comwrote: Friends, I have a file, wherein I have times when employees are scheduled to work. These times

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

$$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 @

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 shapes

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 p align='Left'img src=cid:

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 prafulltjad...@gmail.comwrote: DEAR RAJAN SIR, thanks for reply... but output showing jan and

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 patil.rupesh1...@gmail.comwrote: 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

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 Valluru

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 koul.ash...@gmail.com wrote: is it 1 apr 2013 try to change the setting of ur computer control panel -

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

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 koul.ash...@gmail.com wrote: how will u verify what are the conditions On Wed, Nov 13, 2013 at 10:57 AM, Rupesh Patil patil.rupesh1...@gmail.com wrote: Hi Experts, I am

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