Exclude first charachter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
Great. Thanks Dave.

davegb said:
strFName = Right(strFName, Len(strFName) - 1)
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"
Click to expand...
Click to expand...
 
A shorter way is:

strFName = Mid(strFName, 2)


Great. Thanks Dave.

davegb said:
strFName = Right(strFName, Len(strFName) - 1)
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"
Click to expand...
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Text Files/Format/Save as .xls for multiple files. 9
I have to run macro twice to work? Why 6
slow macro 3
erasing a character in the 3
Who can tell me where I go wrong? 5
How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format 1
Can VBA use array constants 1
Set formula as variable w/o "=" sign 2

Back
Top