Posted to microsoft.public.excel.worksheet.functions

saveas getting rid of formulas

Posts: n/a

formula help need to get current row

Thanks Everyone what a great site!!!

"Kevin Vaughn" wrote:

Try
=INDIRECT("Domestic!a" & ROW())
--
Kevin Vaughn

"saveas getting rid of formulas" wrote:

I have the following formula
=Domestic!$A$3
but I would like to replace $3 with the current row that I am in
=Domestic!$A$=row() gives me an error.

I'm a rookie at this can anyone help Thanks

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
2 Nesting questions	Starchaser	Excel Worksheet Functions	7	January 20th 06 06:53 PM
How do I convert a formula calculated number to a current value ?	Chandler	New Users to Excel	2	January 2nd 06 12:44 AM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Formula for current month minus one = Quarter number in a macro.	Pank	Excel Discussion (Misc queries)	11	June 22nd 05 02:47 PM
formula IF returning current date	diane	Excel Worksheet Functions	1	March 10th 05 06:54 AM

All times are GMT +1. The time now is 09:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us