Referencing to cells by FormulaR1C1

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Referencing to cells by FormulaR1C1

01-21-2017, 07:51 AM

Filip88

Windows 10 Referencing to cells by FormulaR1C1

Office 2016

Novice

Join Date: Jan 2017

Posts: 12

Quote:

Originally Posted by NoSparks

No. But if you're willing to use a 'normal' formula, this macro along with the UDF, will put a drag-able formula into C6.

I tried your UDF and it works, thank you.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formating all cells in an array based on adjacent cells	deejay	Excel	6	12-20-2016 12:00 PM
Linking cells: can sub-cells move with their master-cell when sorting?	kw01	Excel	1	06-30-2015 05:02 PM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Naming Cells for formula referencing	lynchbro	Excel	6	06-26-2014 07:45 AM
Referencing	darksupernova	Word	4	11-08-2012 03:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:23 PM.