Recent content by MarkGorecki

Skip, Yes I did. Looking at code and understanding the output helps a bunch. Thanks again. Mark

Thank you PH! That was exactly what I needed. Many of these functions are still new to me and yours and Skips information really helps me to learn. Thanks to both of you.

Hi Skip, Sorry about the clarity of my request. I'm actually asking two questions that are linked. 1. The line Month = Range("varRange")(1, 1) does not seem to work. What I wanted to accomplish with this line is to get the value of the first cell of the selected range. In the...

Hello, My code currently allows me to select cells with wich to create a chart. (shown below) Dim varRange As Variant, RangeSel As Range, Month As Variant On Error Resume Next Set varRange = _ Application.InputBox("Select a range of cells:", Type:=8) If IsObject(varRange) =...

Thank you very much! That did the trick.

How would a newbie (like myself) be able to select the cell range using a cursor, instead of hard coding the cell range, then pass the range on to the code? For example, my code has: Dim varRange As Variant On Error Resume Next Set varRange = _ Application.InputBox("Select a...

This is great, but how would a newbie (like myself) be able to select the cell range using a cursor, instead of hard coding the cell range, then pass the range on to the code?