>Hello,
>
>I need to find the VBA syntax that would be the equivalent of the END/DOWN function keys. I have exported data to the WorkSheet and now I want to insert a legend and later a graph after the last row populated.
>
>The syntax from the recorded macro ( Selection.End(xlDown).Select ) does not work. I'd very much appreciate help with the correct syntax.
>
>Have a nice day.
>
>Paige
Maybe something like this:
lcFirst_Col="A"
lcFirst_Row="1"
lcLast_Col="A"
lcLast_Row=transform(reccount()+1)
lcChart_Range=["]+lcFirst_Col+lcFirst_Row+[:]+lcLast_Col+lcLast_Row+["]
oSheet.Range(&lcChart_Range)
Imagination is more important than knowledge