How do I implement my custom function in my VBA code?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How do I implement my custom function in my VBA code?

12-21-2019, 05:56 PM

Bumba

Windows 7 32bit How do I implement my custom function in my VBA code?

Office 2007

Novice

Join Date: Jan 2019

Posts: 26

Attached a sample workbook.

Note: I do not want to hard code the ranges like

Code:

Range("A1").Value = netWT(Range("E4").Value)

but make them dynamic, like the range to copy data from and paste data to should be done dynamically in a loop or something.

Attached Files

sample.xlsm (19.6 KB, 8 views)

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
VBA code to save to individual files and skipif function	beefcake2000	Mail Merge	2	12-05-2017 03:19 AM
Custom ribbon button or shortcut for a specific function	Nicobisgaard	Word	6	04-22-2015 04:39 AM
Custom fields used in the Compare Function	OTPM	Project	3	03-02-2015 06:43 AM
Custom formatting code - rounding problem	venkys4u	Excel	1	08-14-2012 07:45 PM
Change format of date when using Now function in VB code	Bondai	Excel Programming	2	03-02-2012 05:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 AM.