Results 1 to 20 of 31

Thread: Whats wrong with my code, copy paste does not change Array formula

Thread Tools
- Show Printable Version
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

10-02-2016, 07:22 PM #15
Paul_Hossler

View Profile

View Forum Posts
VBAX Sage

Joined

Apr 2007

Location

United States

Posts

8,888

Location
Originally Posted by MrSams

How do we do this Paul? If We do a simple =I:49 in B49 once the macro runs the numbers don't move down nor match each other

The formula in the formula bar for the orange cells in the screen shot seems to work for me

As you can see, I inserted 7/18/2016 data into I49:N49 and the B49:E49 data was updated

Change ALL of the B:E array formulas to that and then see if the Insert Copied Cells is correctly updated

Do something similar for the formulas in col N

If you want to look at the answers in the back of the book for even numbered problems, look at this attachment

Attached Files

TS 4+ BB Game 3 (Macro Numbers Input)_phh.xlsm (842.6 KB, 10 views)
---------------------------------------------------------------------------------------------------------------------

Paul

Remember: Tell us WHAT you want to do, not HOW you think you want to do it

1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Reply With Quote