Macros in my spreadsheet
Closed
artyguns
TrowaD
- Posts
- 1
- Registration date
- Thursday November 15, 2012
- Status
- Member
- Last seen
- November 15, 2012
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Macros in my spreadsheet
- A macro to create new spreadsheet and copy data ✓ - Forum - Excel
- Excel 2010-VB Macro formula into many spreadsheets ✓ - Forum - Excel
- Spreadsheet formula - Articles
- Spreadsheet concepts - Articles
- Functions of spreadsheet - Articles
1 reply
TrowaD
Nov 26, 2012 at 09:58 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Nov 26, 2012 at 09:58 AM
Hi Artyguns,
Not clear to me.
You want to fill certain cells with formula's and then autofill those formula's down.
How far down?
quote
when I click on the command button, the cell J3 is not updated with the formula
unquote
What is the deal here, put formula in J3 or not?
quote
I have to create the formula so that there's another value in this cell when I run the macro
unquote
Are we still talking about J3?, what will the formula be?
quote
then the existing column J becomes column K and so on.
unquote
By this you mean to insert a column before column J, making all the formula's move a column to the right?
Best regards,
Trowa
Not clear to me.
You want to fill certain cells with formula's and then autofill those formula's down.
How far down?
quote
when I click on the command button, the cell J3 is not updated with the formula
unquote
What is the deal here, put formula in J3 or not?
quote
I have to create the formula so that there's another value in this cell when I run the macro
unquote
Are we still talking about J3?, what will the formula be?
quote
then the existing column J becomes column K and so on.
unquote
By this you mean to insert a column before column J, making all the formula's move a column to the right?
Best regards,
Trowa