Posted to microsoft.public.excel.programming

Ed[_9_]

external usenet poster

Posts: 194

Code to enter formula w/ relative row ref?

I have a formula (courtesy of J.E. McGimpsey - thank you!!) as follows:
=LEFT(A1&".0.0.",FIND("$",SUBSTITUTE(A1&".0.0.",". ","$",3))-1)

I'm trying to create a macro that will enter this in any cell of any row and
pick up the ActiveCell row reference. So A1 would be "A & ActiveCellRow".
I've tried several ways, but get lost in parenthesis, quotes and
double-quotes, and VBA Expected End of Statement errors.

Any assistance is greatly appreciated.

Ed

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Enter after scanning in a Bar Code	David	Setting up and Configuration of Excel	0	November 30th 07 03:34 AM
Need VBA code to enter text into a textbox !!!!	Art Ferdinand	Excel Discussion (Misc queries)	1	May 6th 05 01:47 PM
Relative Cell References within VBA code	Jandy	Excel Discussion (Misc queries)	2	April 21st 05 02:17 AM
ALT + enter or Char(13) in code	JL	Excel Discussion (Misc queries)	3	April 8th 05 05:27 PM
Enter text in cell Code	Kelly[_5_]	Excel Programming	5	August 23rd 03 08:47 AM

All times are GMT +1. The time now is 07:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us