RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

You can use this for text also Sub isExist() On Error Resume Next If WorksheetFunction.Match(Range("rngValues").Text, Worksheets("Sheet2").Range("d4:d10"), 0) Then If Err.Number = 1004 Then Err.Clear On Error GoTo 0: On Error GoTo -1 MsgBox "Values not fo

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

try Option Explicit Sub Look2() Dim mf As Range Set mf = Sheet2.Columns("D").Find(What:=Range("b4"), _ LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _ searchDirection:=xlNext, SearchFormat:=False) If Not mf Is Nothing Then MsgBox mf.Row End Sub Don Guillett SalesAid Software

RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Try this one: Sub isExist() On Error Resume Next If WorksheetFunction.Match(Range("rngValues").Value, Range("List"), 0) Then If Err.Number = 1004 Then Err.clear On error goto 0:on Error Goto -1 MsgBox "Values not found" Else MsgBox Range("rngValues").Value

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Please ignore previous mail..use it Function check_value(rng As Range) As String Dim cell, rng1 As Range Set rng1 = Sheet2.Range("D4:D10") For Each cell In rng1 If cell.Value = rng.Value Then MsgBox "Bill is made of this Chassis", vbInformation Exit Function End If Next cell End Func

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Excel 2007 File Type Extension - xlsx - Excel 2007 XML Workbook - xlsm - Excel 2007 XML Macro-Enabled Workbook - xltx - Excel 2007 XML Template - xltm - Excel 2007 XML Macro-Enabled Template - xlsb - Excel 2007 binary wo

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Please try below code... Function check_value(rng As Range) As String Dim cell, rng1 As Range Set rng1 = Sheet2.Range("D4:D10") For Each cell In rng1 If cell.Value = rng.Value Then MsgBox "Bill is made of this Chassis", vbInformation End If Exit Function Next cell End Function see a

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

use concatenate function or & operator like =A1 & B1 & C1 etc On Tue, Mar 8, 2011 at 3:02 PM, sudhir kumar wrote: > Hi, > > Can u send Excel Sheet of this example. > > thanx > > > On 7 March 2011 12:17, Krish wrote: > >> Hi , >> >> I have data in row and column 1-3, and needs to club the

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

Hi, Can u send Excel Sheet of this example. thanx On 7 March 2011 12:17, Krish wrote: > Hi , > > I have data in row and column 1-3, and needs to club the data in > single row and column since the data acorss three columns, > > Pls help me. > > Regards, > Krish Kandy. > > -- > > ---

Re: $$Excel-Macros$$ need help in excel

This info helped me too. On Tue, Dec 15, 2009 at 1:24 PM, vinod rao wrote: > Thank you for all of my excel experts. > > On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > >> Hi Friends, >> >> I have 2 excel file having 12 sheets in it, what I want is to merge two >> file into one. I tried usi

Re: $$Excel-Macros$$ need help in excel

Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > Hi Friends, > > I have 2 excel file having 12 sheets in it, what I want is to merge two > file into one. I tried using move or copy but it din't work. Is there any > method. Please not that i have formula

Re: $$Excel-Macros$$ need help in excel

e > > Hi Shilpa, > > Just to add to Mahesh's email .. this will work if you open both Excel > workbooks in the same Excel 'window'. > > Thanks, > > Amitabh > > ------ > Date: Wed, 2 Dec 2009 17:00:52 +0530 > Subject: R

RE: $$Excel-Macros$$ need help in excel

Hi Shilpa, Just to add to Mahesh's email .. this will work if you open both Excel workbooks in the same Excel 'window'. Thanks, Amitabh Date: Wed, 2 Dec 2009 17:00:52 +0530 Subject: Re: $$Excel-Macros$$ need help in excel From: mahender.bi...@gmail.com T

Re: $$Excel-Macros$$ need help in excel

Hi Shilpa, Open both the files(Ex:- A & B) and the select all the sheet u want move from B to A. Then right click on the tab and select move, w will see a new pop- up select Sheet A and press ok. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > Hi Friends, > > I have 2 excel file having 12

Re: $$Excel-Macros$$ need help in excel

Hi Shilpa, please send me file Regards Amresh On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > Hi Friends, > > I have 2 excel file having 12 sheets in it, what I want is to merge two > file into one. I tried using move or copy but it din't work. Is there any > method. Please not that i have