Category "worksheet"

For loop through different excel files AND different worksheets (Matlab)

I try to loop not only through different excel sheets(~125), but also through different excel files (~12). I managed to write a code for the sheets, but now I

How to get text from wrapped text show on different columns using VBA

I have a vba script that copies and paste data from one workbook to the other. The data that is being pasted over are wrapped text. I need my vba script to take

INDIRECT and CELL to dynamically get value from other worksheet, not working

Trying to dynamically get cell value from worksheet in same workbook, depending on worksheet name in column E =IF(E108<>"",INDIRECT(CELL("contents", E108)

HYPERLINK not working with particular sheet names

I have a workbook - lets call it Book1 Book1 contains 5 worksheets; Sheet1, Sheet1A, Sheet2, Sheet2A, Summary Within the Summary worksheet there is a table whic