ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sendkeys examples in excel (https://www.excelbanter.com/excel-programming/340627-sendkeys-examples-excel.html)

EM3553

sendkeys examples in excel
 
I need to move in different cells to write a value from clipboard. How I
indicate to macro to down only one space.

Jim Rech

sendkeys examples in excel
 
Never use Sendkeys unless it's the only way (it seldom is). To select the
cell below the active cell:

ActiveCell.Offset(1).Select

--
Jim
"EM3553" wrote in message
...
|I need to move in different cells to write a value from clipboard. How I
| indicate to macro to down only one space.




All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com