In an excel spreadsheet write the text in cell E$1$ testing for loop Write a program to take the text in E$1$ and copy it vertically starting in cell E$2$ using offset and a loop to go over number of characters, you will also paint every other cell yellow $($highlighting every other cell vertically$).$ You will need to use the VBA function: SyntaxMid$($string$,$ start, $[$ length $])$Returns a String containing a specified number of characters from a string. SyntaxLen$($string $|$ varname$)$Returns a Long containing the number of characters in a string or the number of bytes required to store a variable.