In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
which is taking each URL from sheet1 "B1" and placing it into sheet2 "A1" in a loop. I would like to change the following,
Sub loopA() Dim cel As Range Dim mySheet As Worksheet Set mySheet = Sheets("sheet2") For Each cel In Sheets("sheet1").Range("B" & Sheets("sheet1").Range("B1").End(xlDown).Row & ":B" & Sheets("sheet1").Range("B" & Rows.Count).End(xlUp).Row) mySheet.Range("A1") = cel.Value Next cel End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.