-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
rangeahudata.cellsi
-
T
VBA to get data from closed notebook and deposit new workbook output into a different file location
All, I developed a process for a small data set and it now needs to scale to cover large data grabs from outside of the workbook (in closed workbooks on a drive) then have the macro deposit the output into new workbooks in a different file folder (currently my code drops the new workbooks into...- TommyNewtoExcel
- Thread
- application.goto dim rangeahudata.cellsi string workbook
- Replies: 0
- Forum: Excel Questions
-
T
run time error issue in VBA
I am receiving a runtime error 1004 in VBA. It has been driving me crazy. I run a similar line of code three times before this one and this is the only one I am getting hung up on. Somehow it seems I have improperly set the range? It is giving the reference is not valid. Any help would be...- TommyNewtoExcel
- Thread
- application.goto code dim rangeahudata.cellsi string
- Replies: 1
- Forum: Excel Questions
-
T
run time error issue in VBA
Hello, I am new to excel VBA and have been getting stuck on the "run-time error'1004. The formula is missing a range reference or a defined name" the error is in the following line Range("RIFEquipmentTag").Value = RIFEquipmentTag I believe I have set it up the same way as the other items...- TommyNewtoExcel
- Thread
- application.goto dim rangeahudata.cellsi rifequipmenttag string
- Replies: 7
- Forum: Excel Questions
