Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find 4.75 and Replace with 12.75 ( Rowheight )
Hello from Steved
Please is there away to Find 4.75 and Replace with 12.75 ( Rowheight ). I have other row heights in the same worksheet. I thankyou. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find 4.75 and Replace with 12.75 ( Rowheight )
Are you willing to write a macro to do this? If so:
while activecell.row <= 100 if (selection.rowheight = 4.75) then Selection.RowHeight = 12.75 end if ActiveCell.Offset(1, 0).Select wend This assumes you want to scan through 100 rows. If you have a column that is complete full of text/values, you can change the while line to: while activecell.value < "" Bob Tulk MOUS (XP/97) "Steved" wrote: Hello from Steved Please is there away to Find 4.75 and Replace with 12.75 ( Rowheight ). I have other row heights in the same worksheet. I thankyou. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find 4.75 and Replace with 12.75 ( Rowheight )
Hello BobT
Yes and Thankyou Steved "BobT" wrote: Are you willing to write a macro to do this? If so: while activecell.row <= 100 if (selection.rowheight = 4.75) then Selection.RowHeight = 12.75 end if ActiveCell.Offset(1, 0).Select wend This assumes you want to scan through 100 rows. If you have a column that is complete full of text/values, you can change the while line to: while activecell.value < "" Bob Tulk MOUS (XP/97) "Steved" wrote: Hello from Steved Please is there away to Find 4.75 and Replace with 12.75 ( Rowheight ). I have other row heights in the same worksheet. I thankyou. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
Find and replace | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |