I'm using the below code to try and insert the "Value1" formula into the ActiveCell (i.e. the cell in the first blank row offset by a column, which would be in column B). Whenever I try running the code I get Run-time Error '1004': Application-defined or object-defined error for the "ActiveCell.FormulaR1C1 = Value1" line in the code. If someone could please help me figure this out that'd be great! Thank you!
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Not tested but try this:
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
Unfortunately none of those worked. I'm still getting the same error.
It ran on my system, can you:Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Attached is a file to use, per your suggestion. As I mention in the cell in the "After" sheet, I'm trying to get the formula inserted into that cell in the first blank cell of column B. Let me know if you have any questions.
Hi BigTenBoy,
Thanks for the rep!
This works for me:
Please Login or Register to view this content.
When I tried it in my other workbook it created a circular reference and my spreadsheet went crazy. Any reason why? I tried using ActiveCell.Offset(-1,0) instead of ActiveCell.Address in the later part of the code but that brought back the original error I had before.
I didn't test your Do...Loop; that would be my guess - try the formula without that Do...Loop
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks