Hello!
I'm working on a thing where I will be running a loop to caluclate
results based on a G and E variables. The ultimate goal is to get to a
thing that has all of the results in a table, where I have a value for
G1*E1, G1*E2, G2*E1, G2*E2 (Think of a big old multiplication table).
So the macro plugs in G1 and E1 into the formula (it's too long to use
lookups and if statements) and then pulls the result into my new,
glorifed multiplication table into the corresponding G1*E1 Cell and
then ups the Count of the Loop (ERateCount) by 1.
Works great...Until I need to do G1*E2...how do I get VBA to offset
where it pops the result in the next column without "naming" each
result cell? The G row heading has a name (GStart), so I was thinking
of doing:
Range("GStart").Select
ActiveCell.Offset(0,ERateCount).Select
'where it would offset the column by the loop number...Remember,
ERateCount is upped with each loop.
But I can't make it work...
Thanks, folks, for your help, and sorry if you've addressed this kind
of thing in past posts. I tried looking, but don't think I was using
the right terms.
I appricate your time!!!
-Jess
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
