Thanks a ton to one all really helped me alot in this concern.
On Mon, Jul 18, 2011 at 11:30 PM, Mahesh parab wrote:
> Hi
>
> For Vlookup you can use static Name range which is predetermined
> RANGE
> =SBUMapping!$A$1:$D$789
> OR
> dynamic Name range range which resize dynamically
> RANGE
>
> =O
Hi
For Vlookup you can use static Name range which is predetermined
RANGE
=SBUMapping!$A$1:$D$789
OR
dynamic Name range range which resize dynamically
RANGE
=OFFSET(SBUMapping!$A$1,0,0,COUNTA(SBUMapping!$A:$A),COUNTA(SBUMapping!$1:$1))
Thanks
Mahesh
On Mon, Jul 18, 2011 at 11:05 PM, Mahesh par
Hi Prathima
Assuming your Data 1,2 & 3 columns contain data
Try :
Sub test()
Dim LR As Long
Sheets("Summary").Select
Set Found = Sheets("Summary").Rows(1).Find(what:="Data 1", LookIn:=xlValues,
lookat:=xlWhole)
LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
Found.Offset(, 1).EntireColumn.In
You can always use the .FormulaR1C1 to do the trick.
something like
Cells(1,"A").FormulaR1C1 = "=Vlookup(
TM
On Jul 19, 12:03 am, "Rajan_Verma" wrote:
> Use
>
> Application.Vlookup(LookupValue,LookupRange,Col,Type) in codes
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@goog
Use
Application.Vlookup(LookupValue,LookupRange,Col,Type) in codes
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prathima R
Sent: Sunday, July 17, 2011 12:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ to find particular column and