View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
StephanieH StephanieH is offline
external usenet poster
 
Posts: 95
Default Exclude first charachter

Great. Thanks Dave.

"davegb" wrote:

strFName = Right(strFName, Len(strFName) - 1)

StephanieH wrote:
How do I exclude the "=" from my formula?
I'm using:
AAWGDFormula = ActiveCell.Formula
where my ActiveCell.Formula is
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599" to assign it
as a variable.

Instead of AAWGDFormula reading
"=[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"
I want it to read
"[RecOuts_AutoFeed.xls]dbo_t_Report_OutstandingsByScor!$D$2599"