Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rybred
-
Using variables in a Range
that array code works great, and with the activecell.row as a variable there is only one input the user has to enter. Thank you to all for the tips and info:)- rybred
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using variables in a Range
I'm not exactly sure on how to get the loop to work, im just guessing: Dim columnGroup As Variant columnGroup = Array(2, 3, 7, 8, 12, 16) Dim i As Integer .... For i = ? To ? Cells(currentRow, columnGroup).Activate ActiveSheet.FormulaR1C1 = (dataLink & productRow) Next i i...- rybred
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using variables in a Range
It worked, it does what i originally wanted, pretty basic i know. I used Cells(), im sure the code is quite non-efficient, but i really dont know any vb. Thanks much for the info tranpkp! Here is the macro: Sub Proprod() Dim idrowp Dim idrowc Dim frmentr idrowc =...- rybred
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using variables in a Range
Im quite new to VB, basically i've seen a range specified like: Range("B4,C4,F4,H4").Select I was just wondering how i could get variables to specify a range of cells. I need the macro to paste data, in columns on the same row, the column will not be changing, but the macro will be...- rybred
- Thread
- Replies: 14
- Forum: VBA Visual Basic for Applications (Microsoft)
