ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   move down 23 lines and make the 23rd line height 92.25 (https://www.excelbanter.com/excel-programming/332560-move-down-23-lines-make-23rd-line-height-92-25-a.html)

jaxie

move down 23 lines and make the 23rd line height 92.25
 
Looking to automate a task that will move the current cell down 23 lines and
make the 23rd line row height 92.25. Have no experience with macros.


Todd

Tom Ogilvy

move down 23 lines and make the 23rd line height 92.25
 
sub Movedown()
activecell.offset(22,0).Select
selection.EntireRow.RowHeight = 92.25
End Sub

To learn about macros:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Regards,
Tom Ogilvy


"jaxie" wrote in message
...
Looking to automate a task that will move the current cell down 23 lines

and
make the 23rd line row height 92.25. Have no experience with macros.


Todd





All times are GMT +1. The time now is 07:32 AM.

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