First I get the Workbook Sheet name stored in a string variable SheetName
Then I create two variables to get the source sheet cell… SColCount and SRowCount.
I also create two variables for the destination sheet cell… DColCount and DRowCount.
I assign 1 to both those variables.
Now I need to read the cell A1 in Sheetname. How can I transform SColCount and SRowCount (both 1) to A1?
Content goes to variable CelTransfer
Now I need to write CelTransfer at cell A1 of sheet DESTINATION. Again, I will need to write to cell DColCount DRowCount, and it should be A1. How can I do that?
After writing reading and writing first cell, source cell (to be read) must go down while destination cell must go right.
So SRow = SRow+1 and DCol=DCol+1
What I am stuck is at using two variables that are integers to become a cell address.
I tried this formula which I found at another thread, but I got an error message
“compiler error found while processing the formula
Option Strict On does not allow implicit conversions of string into double”??