-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Facts
Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
I am also having trouble with a formula to show the full path and file name.
=cell("filename") returns the file path correctly but returns the file name like this:
[quote45676.xlsm]quote
I need to just be quote45676???
Any ideas would be greatly appreciated.
Thx
Chad
=cell("filename") returns the file path correctly but returns the file name like this:
[quote45676.xlsm]quote
I need to just be quote45676???
Any ideas would be greatly appreciated.
Thx
Chad
Upvote
0
Similar threads
- Question
- Replies
- 0
- Views
- 141
- Replies
- 1
- Views
- 399
- Question
- Replies
- 0
- Views
- 426
- Replies
- 2
- Views
- 147
