Pasting values from a textbox into a single cell on a spreadsheet
Hi there,
I am trying to create a macro that searches for a series of identical
entries in a spreadsheet and produces the sum of a corresponding range of
other variables in the spreadsheet (Corresponding to the initial set of
entries). I then want to take this sum value (a Long type variable) and paste
it into a cell on the same spreadsheet. I cannot for the life of me get this
simple paste to work. As of now the macro finds the value so the bulk of my
code works fine, it is just the paste problem that I have. I would greatly
appreciate any help.
Regards,
Jordan
|