I have a macro that looks up the OU a server is in. It currently looks at the server name in A2 and returns the OU in B2. Now I want to make it so that it does this for any server entered in column A. How do I retrieve the number of rows
entered?
Currently:
strServerName = Range("A2").Value
do stuff
Range("B2").Value = strEndResult