Macros in my spreadsheet
Closed
artyguns
Posts
1
Registration date
Thursday November 15, 2012
Status
Member
Last seen
November 15, 2012
-
Nov 15, 2012 at 03:53 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 26, 2012 at 09:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 26, 2012 at 09:58 AM
Related:
- Macros in my spreadsheet
- Macros in excel download - Download - Spreadsheets
- Spreadsheet function - Guide
- Google spreadsheet right to left - Guide
- Spell number in excel without macro - Guide
- Excel online macros - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 26, 2012 at 09:58 AM
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