Thread: Getting cells referenced while creating formula
View Single Post
 
Old 04-17-2018, 01:47 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2010 32bit
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Quote:
Originally Posted by jariquelme View Post
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…
Reply With Quote