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!
-
using variables to remember cells for later reference
what, do I get more data? no, not for this project.- Joe2114
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using variables to remember cells for later reference
Oh yeah... I only thought of that before I started putting $ in my formulas... I suppose it would work now... Thanks for pointing out the obvious :)- Joe2114
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using variables to remember cells for later reference
sorry for the awful explanation, but like I said, that was my first post and I was kinda panicking. anyway, unfortunately that didn't quite work as expected. the aim was to be able to: - select Any cell with a number, - have that number be copied to cell AF13, - then the formulas do their...- Joe2114
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using variables to remember cells for later reference
Hi, this is my first post, so here we go... for my Statistics coursework, I am required to find info about a variety of people from a large table of data in excel. I have crafted a series of HLOOKUP formula which return all the relevant data from entry of a randomly generated reference number...- Joe2114
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
