activesheet.range

  1. G

    Trying to MkDir, ActiveWorkbook.SaveAs using cell variables -and failing. What is IfNewFolder?

    I really could use some advice. I am new to this forum, so please forgive my mistakes. Thanks, in advance. I wish to have a button launched macro that saves my workbook to a new folder -both of which are named after cells on the active worksheet. So far, I can get the folder created (from...
  2. H

    Pull out names from a string, into multiple columns?

    Trying to run a quick script to pull a few names out of a string and place them in the column next to the string location. Cant seem to get this going. Any tips would be greatly appreciated. Sub james() Dim celltxt As String celltxt = ActiveSheet.Range("d4").Text If InStr(1, celltxt, "Sue")...

Some videos you may like

This Week's Hot Topics

Top