Skip to content

Instantly share code, notes, and snippets.

@kerrypnx

kerrypnx/thoughout column

Created December 24, 2019 01:42
Show Gist options
  • Save kerrypnx/a69014b444c2e0a853a47badcd7313a9 to your computer and use it in GitHub Desktop.
Save kerrypnx/a69014b444c2e0a853a47badcd7313a9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
thoughout column
bColumnCount = Cells(Rows.Count, 2).End(xlUp).Row
ActiveSheet.Range("B40 : B" & CStr(bColumnCount)).Select
itemsArr = ActiveSheet.Range("B40 : B" & CStr(bColumnCount))
MsgBox itemsArr(1, 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment