Hello All, – thanks in advance , been banging my head against the wall on this one…
I am writing powershell 4.0 code for excel spreadsheet and wanting to copy a specific range of cells IE: AB3 to AB106 using only the visible cells after applying a filter … and copying that whole column of info. BTW only taking the visible code and skipping the first 2 lines of data, therefore specifying a set of data instead of using .entirecolumn… Can’t seem to get the code to work…
I am looking thru the columns in an array, not that that should matter, but just an FYI. the code provided is only that of the loop i am concerned with, the other works great… you will see the remmed out lines work… but this is slow as it goes thru each cell indivifually. I want to take a whole block of code at once. and i can’t use .entirecolumn , due to taking unwanted header data and merged cells on the target worksheet.
$ColArray = @(“AB”,“AC”,“C”,“D”,“e”,“m”,“z”,“AA”)
Foreach ($ItemC in $colArray)
# copy cell from Sheet SPM Daily Report to Report Total