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 Ra

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* > > -- > Are you =EX

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 value. > > -- > Are

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 rcoun

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

Test mail Please ignore Thanks & regards, www.MrExcel4U.com On Thu, Mar 6, 2014 at 5:20 PM, Caroline Campos wrote: > I have two worksheets and I linked the cells to change automatically, but > when I insert a hyperlink in the cell of the original worksheet, it

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).Selec

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

=OFFSET($A$1,0,0,COUNTA(A:A),3) Thanks & regards, www.MrExcel4U.com On Mon, Mar 10, 2014 at 3:12 PM, Prafull Jadhav wrote: > Dear All, > > Good Afternoon, > > I want a examples of Dynamic Range of Pivot. > for example > if i added new data in master file then n

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

Plz share your workbook Thanks & regards, www.MrExcel4U.com On Mon, Mar 10, 2014 at 2:46 AM, Rahman Khan 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" Then > >

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 wrote: > Try this > > > =VLOOKUP($I1,$A$1:$F$9,COLUMN(A$1),0) > > Thanks & rega

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

Try this =VLOOKUP($I1,$A$1:$F$9,COLUMN(A$1),0) Thanks & regards, www.MrExcel4U.com On Thu, Mar 6, 2014 at 4:05 PM, manish jaiswal wrote: > > > On Thursday, March 6, 2014 4:03:30 PM UTC+5:30, manish jaiswal wrote: >> >> Cust#Sold to Cust#Sold to - Name Com

Re: $$Excel-Macros$$ Vlookup problem

Share your workbook plz Thanks & regards, www.MrExcel4U.com On Thu, Mar 6, 2014 at 3:55 PM, Dileep Kumar wrote: > Hi Manish, > > Will you please elobrate with example data. > > > On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal > wrote: > >> >> using vlookup an

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

Plz share your workbook Thanks & regards, www.MrExcel4U.com On Thu, Feb 27, 2014 at 2:06 AM, Hilary Lomotey wrote: > i have written a macro to extract couple of data from another sheet with > advanced filter > > 'extracting equity statement > Sheet24.Range("Eq

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 On Tue, Feb 25, 2014 at 2:54 PM, MH wrote: > > Hello, > > The following code fills the

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$$ 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 On Mon,

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 O

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 On Mon, Feb 17, 2014 at 3:09 PM, Jitender Saini wrote: > Hi Friends, > > Need your help to modify this macro as i m new to VBA. > >

Re: $$Excel-Macros$$- Query

Hi Atul, PFA... Thanks & regards, www.MrExcel4U.com On Mon, Feb 17, 2014 at 1:15 PM, Atul Kesaria wrote: > Hi Team, > > Can some one help. > > Regards > Atul > > > On Wed, Feb 12, 2014 at 1:46 PM, Atul Kesaria wrote: > >> Hi Team, >> >> I need a help in cre

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 wrote: > excellent chief, this is what i needed. thanks all for your assistance > > On 2/15/14, Naveen Kumar M N wrote: > > This message is eligible for Automatic Cleanup! ( > naveenkumarmn...@gmail.com) > > >

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 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 in > column

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 wrote: > > > hi all i want to creat formula as defined below- > - > formula needed for creating Studen

$$Excel-Macros$$ Workbooks consolidation

Hi visit to know how to consolidate workbooks. Workbook Consolidation. 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 th

$$Excel-Macros$$ Excel Charts Gallery

Hi All Visit for Excel Chart Gallery. Excel Charts Gallery 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 @ https://www.facebook.com/dis

$$Excel-Macros$$ E-Books free

Hi All, Download e-books free 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, accura

$$Excel-Macros$$ Excel & VBA

Hi All, Must visit below mentioned ... Happy New Year 2014 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 F