Re: $$Excel-Macros$$ VBA Help

Hi, Please use the below mentioned code on Add command Button click Private Sub CommandButton1_Click() Dim Rcount As Integer Rcount = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row Rcount = Rcount + 1 Range("b" & Rcount).Value = Me.TextBox1.Value ActiveCell.Offset(0, 2).Value = Me.TextBox2.Value

Re: $$Excel-Macros$$ Formula required

plz provide more clearity?? about your query Thanks & regards, www.MrExcel4U.com On Fri, Jun 17, 2016 at 5:26 AM, Rajesh Agarwal wrote: > Dear Sir > > please help me by resolving the issue. > > -- > *Rajesh Kumar Agarwal* > *9811063001*

Re: $$Excel-Macros$$ Help on Vlookup

pfa attached without helping column. Vikas Verma Thanks & regards, www.MrExcel4U.com On Fri, Jun 17, 2016 at 12:22 AM, vikas khen wrote: > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the

Re: $$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

Try thishope it will help you... Sub test() Application.DisplayAlerts = False Application.ScreenUpdating = False Dim rng As Range Dim cell As Range Set rng = Application.InputBox(Select a range, Type:=8) j = 1 For Each cell In rng If cell.DisplayFormat.Interior.Color 16777215 Then rcount =

Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

Test mail Please ignore Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Thu, Mar 6, 2014 at 5:20 PM, Caroline Campos caroline@gmail.comwrote: I have two worksheets and I linked the cells to change automatically, but when I insert a hyperlink in the cell of the

Re: $$Excel-Macros$$ additional row creation

Hi E J try this... Sub testing() Dim rng As Range Dim rcount As Long Dim cel As Range rcount = Sheets(1).Cells(Rows.Count, c).End(xlUp).Row Set rng = Sheets(1).Range(c1:c rcount) For Each cel In rng If cel cel.Offset(1, 0) And cel Then cel.Offset(1, 0).Select

Re: $$Excel-Macros$$ Dynamic Range for Pivot

=OFFSET($A$1,0,0,COUNTA(A:A),3) Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Mar 10, 2014 at 3:12 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Good Afternoon, I want a examples of Dynamic Range of Pivot. for example if i added new data in

Re: $$Excel-Macros$$ IF statements in VBA

Plz share your workbook Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Mar 10, 2014 at 2:46 AM, Rahman Khan rahmandk...@gmail.com wrote: If sh.Range(G11).Value like x...@x.xxx or x...@x.xxx, x...@x.xxx or x...@x.xxx, x...@x.xxx, x...@x.xxx

Re: $$Excel-Macros$$ Vlookup problem

Share your workbook plz Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Thu, Mar 6, 2014 at 3:55 PM, Dileep Kumar deepuk...@gmail.com wrote: Hi Manish, Will you please elobrate with example data. On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal

Re: $$Excel-Macros$$ Re: Vlookup problem

Try this =VLOOKUP($I1,$A$1:$F$9,COLUMN(A$1),0) Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Thu, Mar 6, 2014 at 4:05 PM, manish jaiswal manish88jais...@gmail.comwrote: On Thursday, March 6, 2014 4:03:30 PM UTC+5:30, manish jaiswal wrote: Cust#Sold to

Re: $$Excel-Macros$$ Re: Vlookup problem

=VLOOKUP($I2,$A$1:$F$9,MATCH(L$1,$A$1:$F$1,0),0) Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Thu, Mar 6, 2014 at 4:21 PM, mrExcel4u mr.exce...@gmail.com wrote: Try this =VLOOKUP($I1,$A$1:$F$9,COLUMN(A$1),0) Thanks regards, www.MrExcel4U.com http

Re: $$Excel-Macros$$ Problem with Advanced Filter

Plz share your workbook Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Thu, Feb 27, 2014 at 2:06 AM, Hilary Lomotey resp...@gmail.com wrote: i have written a macro to extract couple of data from another sheet with advanced filter 'extracting equity statement

Re: $$Excel-Macros$$ fill a column with a formula to a specific index.

Sub test11() With Sheets(testing) .Range(F1:F .Cells(Rows.Count, A).End(xlUp).Row) = =SUM(E1,D1) End With End Sub Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Tue, Feb 25, 2014 at 2:54 PM, MH s.mariamha...@gmail.com wrote: Hello, The following code

Re: $$Excel-Macros$$ add a static text in all cells of a column

Try this Sub try() Dim temp As String For i = 1 To Range(A1:A10).Rows.Count ' change row count as per your requirement temp = Cells(i, 2).Value Cells(i, 2).Value = welcome vbTab temp Next End Sub Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Feb 24,

Re: $$Excel-Macros$$ add a static text in all cells of a column

Try this Sub try() Dim temp As String Dim RNG As Range Dim cel As Range Set RNG = Application.InputBox(Select a range, Type:=8) For Each cel In RNG temp = cel.Value cel.Offset(0, 1) = welcome vbTab temp Next cel End Sub Thanks regards, www.MrExcel4U.com

Re: $$Excel-Macros$$ Query for Macro

Try this Sub query() Dim rng As Range Dim cel As Range Set rng = Range(A1:a10) For Each cel In rng If cel = Yes Or cel = No Or cel = Correct Then cel.Offset(0, 1) = Ok End If Next cel End Sub Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Wed, Feb

Re: $$Excel-Macros$$- Query

Hi Atul, PFA... Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi Team, Can some one help. Regards Atul On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria atul.kesa...@gmail.comwrote: Hi

Re: $$Excel-Macros$$ Send mail from excel having specific text : little macro help!

Hi Jatinder,, PFA Hope it will help you.not 100% but u take an idea about the same.. Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Feb 17, 2014 at 3:09 PM, Jitender Saini jeetusain...@gmail.comwrote: Hi Friends, Need your help to modify this macro as i m

Re: $$Excel-Macros$$ For one workbook to another workbook using VBA

Hi Manjunath, PFA... warm regards, On Sun, Feb 16, 2014 at 10:43 PM, Manjunath Narayanappa manjunath.n1...@gmail.com wrote: Hi Experts Could you please help me on it. how to copy specific data from one workbook to another workbook for specific name using VBA Thanks Manjunath --

Re: $$Excel-Macros$$ loop to extract balances

Hi Hilary, Try updated one... PFA On Sat, Feb 15, 2014 at 1:17 PM, Hilary Lomotey resp...@gmail.com wrote: excellent chief, this is what i needed. thanks all for your assistance On 2/15/14, Naveen Kumar M N naveenkumarmn...@gmail.com wrote: This message is eligible for Automatic

Re: $$Excel-Macros$$ loop to extract balances

Hi Hilary, PFA...Hope it will help you.. warm regards, On Fri, Feb 14, 2014 at 10:29 PM, Hilary Lomotey resp...@gmail.com wrote: Hello Experts, i need a little assistance to extract balances from the sheet attached. i have extracted a unique list of names from the transactions. i want a

$$Excel-Macros$$ Workbooks consolidation

Hi visit to know how to consolidate workbooks. Workbook Consolidation.http://mrexcel4u.blogspot.in/2014/01/consolidate-all-files-with-single-click.html Thanks -- 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

Re: $$Excel-Macros$$ help!!! creation code from data in cells

Hi, will you please provide the row data for the same query... thanks On Thu, Jan 2, 2014 at 11:07 PM, abhinav bansal abhifl...@gmail.com wrote: hi all i want to creat formula as defined below- - formula needed for

$$Excel-Macros$$ Excel VBA

Hi All, Must visit below mentioned ... Happy New Year 2014 http://mrexcel4u.blogspot.in/ Thanks regards, -- 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

$$Excel-Macros$$ E-Books free

Hi All, Download e-books free http://mrexcel4u.blogspot.in/ Warm regards, -- 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,

$$Excel-Macros$$ Excel Charts Gallery

Hi All Visit for Excel Chart Gallery. Excel Charts Gallery http://mrexcel4u.blogspot.in/ Thanks regards, Vikas Verma -- 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 @