Geoff, I've never scripted in VBA' that talent falls outside of my discipline. I can write very complicated formulas using Excel's native/built-in functions so I'm sure I possess the logic needed and I'm willing to do it. Step-by-step instructions is not what I asked for. I provided the core...
I think I understand. I'm a network manager and not a developer I need to know how to turn this code into a function? In other words I dunno how to do it. All the functions that I've ever created I was given step-by-step instructions on what to do.
Please help.
Chi
Hi all,
I need to create a function that will take a value and search a range for that value and then copy all of the data on row to a location.
I found this code on the MSDN website:
Sub FindIt()
Dim rng As Range
' Find data and use Resize property to copy range.
Set rng =...
Hi all,
I need to create a function that will take a value and search a range for that value and then copy all of the data on row to a location.
I found this code on the MSDN website:
Sub FindIt()
Dim rng As Range
' Find data and use Resize property to copy range.
Set rng =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.