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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How I might avoid formatting nightmare
I posted a related problem a week ago. This one is a little different. I have 3 units, called Parcel 1, Parcel 2, and Parcel 3. Each Parcel has a consignment size established by the user. For example, Parcel 1 = 50,000. Each Parcel can have up to 5 grades, called Grade 1, Grade 2, Grade 3...- vbab
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel VBA printing query
VBA is not my forte. Thank-you macropod for pointing out the range limits. If I have 5 ranges, say 0-9,999, 10,000-19,999, 20,000-29,999, 30,000-39,999, 40,000-50,000, with constants for each range, 3,500, 4,500, 6,000, 7,000, 8,000, is it possible to group these in the macro? For example, the...- vbab
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel VBA printing query
In my line of work I need users to enter a consignment size, i.e. 25,800. From here, a mini program would... 1. Determine whether the size is between 0-10,000, 10,000-20,000, 20,000-30,000, 30,000-40,000, and 40,000-50,000. 2. Once the correct range is determined, it breaks down that...- vbab
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
