Hi everyone,
*** I have an urgent topic - I hope someone can help ***
As part of a longer vba code (too difficult to give the whole picture), I want to save an array and later paste it (normal and later only format).
I can't figure out the syntax for this quite "simple" operation.
With the help of some other code, these variables have the follwing values (just examples):
StartRow = 11
EndRow = 14
StartColumn = 1
EndColumn = 20
PasteRow1 = 100
PasteColumn1 = 1
PasteRow2 = 120
PasteColumn2 = 1
Steps that I want to do:
1) I first want to copy the area defined by StartRow,StartColumn & EndRow,EndColumn into a variable named "SavedArray" (which then will contain "4 x 20 cells" in this example)
2) Then I want to paste "SavedArray", starting at cell PasteRow1, PasteColumn1. Like in normal Excel go to this specifik cell and press CTRL-V.
3) Then I will change some of the cell values within "StartRow,StartColumn & EndRow,EndColumn" (this I know how to do). However, the content of "SavedArray" must NOT be affected!
4) Then I want to "paste special" (only formats) the "SavedArrey" starting at cell PasteRow2, PasteColumn2. Like in normal Excel go to this cell and press "Paste Special" / "Formats". Since I meanwhile have changed the content of the cells from which "SavedArray" was copied, it must be the original content of SavedArray.
Many thanks in advance!
Bjorn
Bookmarks