Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
With shtTo Dim from As Range Dim too As Range 'specifying addresses copXrow = xRows - 1 copxRows = shtTo.Cells(1).CurrentRegion.Columns(1).SpecialCells(xlCellTypeVisible).Count 'setting from range Set from = Range("M" & copXrow & ":" & "EA" & copXrow) 'setting to range Set too = Range("M" & lastrow & ":" & "EA" & lastrow) 'autofill from too Range("from").AutoFill Destination:=shtTo.Range("too") End With
Join the community of 500,000 technology professionals and ask your questions.