Posted by Yuniati on May 07, 2001 5:05 PM
I'm in the middle of making a macro for Excel 2000.
I have two questions.
1. I wanted a return value/string of current cursor position.
For instance, my cursor is now at B200 (and always change). How do I write the macro program for this?
2. Related to the first question, I wanted to run a Histogram (from Tools - Data Analysis - Histogram) for B1:B200. Below is my script, it means that the Histogram add-ins analyze data in range B1:B200 and put the result in F1. How do I change the range automatically if for the next data set the range are different?
Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$B$1:$B$200"), _
ActiveSheet.Range("$F$1"), , False, False, False, True
Thanks in advance. Yuniati.