Getting cells referenced while creating formula

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Getting cells referenced while creating formula

04-17-2018, 01:47 AM

p45cal

Windows 10 Getting cells referenced while creating formula

Office 2010 32bit

Expert

Join Date: Apr 2014

Posts: 956

Quote:

Originally Posted by jariquelme

Hi p45cal.

I need to know the range selected while creating the formula. Selection.Address(0,0) is only set when I accept the edition.

TIA

I haven't the foggiest what you mean but:

Code:

range("H5").Formula = "=SUM(" & Selection.address(0,0) & ")"

Perhaps if you described th background behind what you're trying to do…

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling a formula down a column where only one cell value referenced changes?	takamaz	Excel	2	03-11-2018 08:56 AM
Creating a Text Entry That Holds a Property and Can Be Referenced Elsewhere	mike_302	Word	2	01-17-2018 06:03 AM
Shorter VBA for creating borders for cells	mbesspiata	Excel	2	07-28-2014 12:37 PM
Formula to hide '0' from blank referenced cells	formuladummy	Excel	3	05-08-2014 02:33 AM
Help with creating a Formula, please	websiteaog	Excel	9	11-25-2010 04:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:30 AM.