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!
-
Relative cell referencing
Help please! I have a cell c8 in sheet1 whose value is from the result of the maxnumber in a table in sheet2. How do I insert in c9 in sheet1 the value in columnA in sheet2 corresponding to the same row the maxnumber was found? Basically in sheet2 column A represents dates so I would like to...- musha26
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA subscript out of range error
Hi I have just started learning VBA and I have an error coming up "subs cript out of range error) I just have 2 workesheets in a workbook, one with a table of numbers, and I'm trying to get the minimum value within teh range and insert it in cell d5 of the previous worksheet. here's my code...- musha26
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
