Fwd: $$Excel-Macros$$ Insert picture in an excel's many sheets

2013-06-07 Thread Pravin Gunjal
Thanks Ashish Jee Both the codes are working fine for one picture, but what if I wants to insert to picture instead of one? Thanks Pravin Gunjal -- Forwarded message -- From: ashish koul Date: Fri, Jun 7, 2013 at 8:02 PM Subject: Re: $$Excel-Macros$$ Insert picture in an excel's

Fwd: $$Excel-Macros$$ Insert Logo in Excel

2013-06-07 Thread Pravin Gunjal
Thanks Vijay Jee it's a great help. Pravin. -- Forwarded message -- From: P.VIJAYKUMAR Date: Fri, Jun 7, 2013 at 7:41 PM Subject: Re: $$Excel-Macros$$ Insert Logo in Excel To: "excel-macros@googlegroups.com" Respected Pravin, Check the following link http://www.techrepublic.c

$$Excel-Macros$$ URGENT: Direct client requirement NJJUD-Business Analyst 3 (328218) Mercer County NJ F2F required

2013-06-07 Thread sindhu amensys
Hi, Hope you are doing Great This is sindhu from *AMENSYS INC*.We are immediately looking for *Business Analyst** *at *Mercer County NJ * with one Of Our Direct clients. If You Are interested Or know someone who is looking for projects, please reply me the details ASAP to *sin...@amen

$$Excel-Macros$$ Direct client requirement for NJJUD-Product Specialist (328204) Java developer Trenton, NJ 08625 F2f REQUIRED

2013-06-07 Thread sindhu amensys
Hi, Hope you are doing Great This is sindhu from *AMENSYS INC*.We are immediately looking for *Java developer *at *Trenton, NJ * with one Of Our Direct clients. If You Are interested Or know someone who is looking for projects, please reply me the details ASAP to *sin...@amensys.com *

$$Excel-Macros$$ Need help on worksheet protect and unprotect code

2013-06-07 Thread maksood alam
Hi Guys, I have workbook with codeing below Private Sub Worksheet_Change(ByVal Target As Range) *Sheets("MMPs").Unprotect "1234"* ** If ActiveSheet.Name = "MMPs" And Target.Column = 2 Then If Selection.Value = "F" Then Selection.EntireRow.Interior.Color = vbYellow ElseIf Selectio

$$Excel-Macros$$ DSS Software Test Analyst 4 in Richmond, VA F2F required long term contract

2013-06-07 Thread sindhu amensys
Dear Candidate, Our records shows that you are experienced IT professional. We have an urgent Requirement for below position. Please go through the requirement and if you comfortable with this positions revert back to with your updated Resume, contact details and expected rate. Role: DSS So

$$Excel-Macros$$ Direct client Requirement for DMV TFS Administrator (329897) Richmond VA for 3 months

2013-06-07 Thread sindhu amensys
Dear Candidate, Our records shows that you are experienced IT professional. We have an urgent Requirement for below position. Please go through the requirement and if you comfortable with this positions revert back to with your updated Resume, contact details and expected rate. Role: DMV TF

Re: $$Excel-Macros$$ Insert picture in an excel's many sheets

2013-06-07 Thread ashish koul
add image to first sheet then re-size it as per ur requriment then try this macro Sub test2() Dim i As Long Sheet1.Shapes("Picture 1").Copy For i = 2 To Sheets.Count Sheets(i).Paste Sheets(i).Shapes(Sheets(i).Shapes.Count).Top = Sheet1.Shapes("Picture 1").Top Sheets(i)

Re: $$Excel-Macros$$ Insert Logo in Excel

2013-06-07 Thread P.VIJAYKUMAR
Respected Pravin, Check the following link http://www.techrepublic.com/blog/msoffice/quickly-add-a-header-or-footer-to-every-sheet-in-an-excel-workbook/6601. it might be of some help to you Regards, VIJAYKUMAR On Fri, Jun 7, 2013 at 6:42 PM, Pravin Gunjal wrote: > I have attached a sample fil

Re: $$Excel-Macros$$ List in Userform

2013-06-07 Thread Bé Trần Văn
You use a label for each name. 2013/6/7 Chandra Shekar > Hi, > > How to get List as attached in the userform > > > Regards, > > Chandra > > -- > 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:/

$$Excel-Macros$$ Insert Logo in Excel

2013-06-07 Thread Pravin Gunjal
I have attached a sample file with logo of a company. I want this logo (or any other picture/logo) to be inserted in all the sheets at a time. How this can be done, please advice. Thanks in advance. Regards Pravin Gunjal. -- Forwarded message -- From: ashish koul Date: Thu, Ju

$$Excel-Macros$$ List in Userform

2013-06-07 Thread Chandra Shekar
Hi, How to get List as attached in the userform Regards, Chandra -- 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

$$Excel-Macros$$ Help Pivot table gives error when adding to "addDataFiled"

2013-06-07 Thread Jorge Marques
Hi guys, I don't know why but I have this recorded macro, that always gives me an error when is putting the field "QTY" - Quantity in the Values field? Can you help me? Private Sub splitf() Application.ScreenUpdating = False Range("A1").Select Range(Selection, Selection.End(xlToRight

Re: $$Excel-Macros$$ Help delete rows with dynamic worksheets

2013-06-07 Thread Jorge Marques
Works perfectly :), thanks a million. On 6 June 2013 17:01, ashish koul wrote: > see if it helps > Sub test() > Dim wk As Worksheet > Dim i As Long > Application.ScreenUpdating = False > Application.DisplayAlerts = False > Application.Calculation = xlCalculationManual > > For Each wk In ThisWork

Re: $$Excel-Macros$$ find and remove text

2013-06-07 Thread Rahul Sharma
but brother, u have mentioned only "-", i have lots of string in that like *comma, dash,bracket, * so how to combine all the special character in one. On Friday, June 7, 2013 12:47:47 PM UTC+5:30, XLS S wrote: > > try below formula > > combination with Left and find formula > > =LEFT(G10,FIND(

Re: $$Excel-Macros$$ find and remove text

2013-06-07 Thread xlstime
try below formula combination with Left and find formula =LEFT(G10,FIND("-",G10)-1) . Enjoy Team XLS On Fri, Jun 7, 2013 at 12:13 PM, Rahul Sharma wrote: > hi folks, > i need a formula that can find the text string and remove from the name. i > have 1500 name store