Copy Spinners with Macro

Hi,

I have a macro that "refreshes" a sheet by copy-pasting the functions in a given cell downwards (all of the cells that are copied to be pasted are in row 4). The macro works, except not for spinners. I have five spinners (in cells O4, R4, U4, X4, and AA4) that need to be copied downwards x number of times (depending on the number of user-entered values in column B), all with links to cells AE4, AF4, AG4, AH4, and AI4, respectively. The spinners that would be pasted downwards would need to reference cells in the same row (i.e. the spinner that was pasted in O5 should reference AE5, the spinner pasted in O6 should reference AE6, etc.). I've attached the macro for reference.

I'm new to VBA so am figuring things out as I go, but am stumped on this one. Any ideas? Thanks!

Please Login or Register  to view this content.

Any help on this would still be much appreciated...

Thanks for the reply! I've attached a sample book below. Unfortunately, most of the formulas rely on a certain plug-in, which is why I hadn't previously attached the book. That being said, the spinners in question aren't directly related to them, so getting them to copy-paste shouldn't be related to the plug-in's formulas.

The spinners were inserted as form controls, and their properties were set to have a maximum value of 10, moving in increments of 1. The results of clicking them will only be seen on the sheet when the value in column A is set to "Manual" for a given row.

Thanks!

This worked perfectly, thanks a bunch! I appreciate the help.