functions vba

  1. D

    passing sheet address to subroutine

    what is a correct way to access a open workbook.sheet that is currently open when linking to a subroutine or a function? ie.. i open two workbooks in the main routine and the based on a condition in the main routine i link to a subroutine. I can't figure out how to read a value on the open...
  2. D

    Check if sheet exists while looping through workbooks

    Hi all, can anyone help me call this function? I found this function to check if a sheet exists but I dont know how to call it. The macro looks at a folder and opens every excel workbook in it, extracting data. I am adding the fucntion for the eventuality that the user point the folderpicker...

Some videos you may like

This Week's Hot Topics