Using VBA to return values from several cells as a formula.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Using VBA to return values from several cells as a formula.

05-24-2023, 04:53 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

Why don't you simply use a formula in target sheet (Sheet2!Q165)

Code:

=SUM(Sheet1A23:A25)

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to match one list with another and return certain values from corresponding cells in excel	Oluagbe1	Excel	10	02-11-2019 07:00 PM
Loop through cells and return only unique values	trevorc	Excel Programming	4	10-11-2018 03:49 PM
have a formula that combines two cells return a zero instead of a blank cell	Kubi	Excel	3	08-07-2017 11:52 PM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:25 AM.