Entering Formula in VB

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Entering Formula in VB

FAQ

Thread Tools

Display Modes

09-02-2018, 06:19 PM

Khwaja

Windows 10 Entering Formula in VB

Office 2016

Novice

Join Date: Aug 2018

Posts: 12

Thanks a lot. I am using the following code in the light of changes you suggested. But I am getting runtime error 9. Subscript out of range.

MyFileName = CurrentWB.Path & "\QBOUploads\" & Sheets("Analysis").Range("I1").Value & Format(Now(), "dd-mm-yyyy") & ".csv"

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
entering name in outlook does not autofill	Franksplace2	Word	0	03-08-2015 04:10 PM
entering duration in months	ketanco	Project	1	12-17-2014 01:09 PM
entering lump sum costs	ketanco	Project	1	12-24-2011 12:56 PM
Entering Contact details	GemmaD	Outlook	0	12-18-2008 06:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:32 PM.