Re: $$Excel-Macros$$ sheet name as variable

check the attachment see if it helps On Fri, Nov 9, 2012 at 8:00 PM, Divaker Pandey wrote: > > Is there any way to make reference like it > DataTabTemp!$1:$1 > > i want to keep sheet name variable > > MATCH("EVAMOMARGIMP10",DataTabTemp!$1:$1,0) > > actully i have data in two sheet "DataTabTem

$$Excel-Macros$$ sheet name as variable

Is there any way to make reference like it DataTabTemp!$1:$1 i want to keep sheet name variable MATCH("EVAMOMARGIMP10",DataTabTemp!$1:$1,0) actully i have data in two sheet "DataTabTemp" and "DataTabUS" and now i need to change formula on whole application so i don't used anoter formula, but