View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Andrew Taylor Andrew Taylor is offline
external usenet poster
 
Posts: 225
Default Exclude first charachter

A shorter way is:

strFName = Mid(strFName, 2)



StephanieH wrote:
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"