range of cells & SendKeys

Hi guys


You can see the range is A1:A100, I always change this range in below VBA code manually as per need.

I'm using this formula -----"A1:A"&COUNTA(A:A)---in cell H2 to show the range.

I do not know how to change this VBA code to mention the range is in H2 cell rather than using [A1:A100]

could you please help.

Thanks

HTML Code: 

Try to avoid SendKeys() if at all possible.

What is the purpose, to set formula values as static values? If so:

Please Login or Register  to view this content.

Originally Posted by bakerman2

Please Login or Register  to view this content.

Thank you very much , it is working perfectly
but
is it possible to use H2 cell as range in this code ?

Originally Posted by Kenneth Hobson

Try to avoid SendKeys() if at all possible.

What is the purpose, to set formula values as static values? If so:

Please Login or Register  to view this content.

Thanks
Sorry, I did not mention, I'm sending keys from excel to other software so I think , I may have to use send keys .

Thanks

After sending keys (a1:a100) to other software ... Which key code can be used to go to first cell in the destination software where the first entry has been send from excel.
The destination software has no cell reference.

For example

The values of A1 cell in excel is 123
I send 100 key strokes to other software ,this software receives data from excel in column cell be cell.
I want when the other software receives last key stroke from excel from cell A100 then by any KEY CODE it should only go to the first cell where the value 123 lies . By up arrow or page up or scroll up

Cheers
Thanks

That is beyond the scope of what we can tell you. Do it manually and write down your key combinations.