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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:15 PM.