G Guest Dec 16, 2003 #2 -----Original Message----- Can I use the IsNumber fuction in my macro's . Yes, try something like this Click to expand... For each c in Selection
-----Original Message----- Can I use the IsNumber fuction in my macro's . Yes, try something like this Click to expand... For each c in Selection
P Peter Atherton Dec 16, 2003 #3 Yes use something like this For Each c in selection If isnumeric(c) then c.value= C*2 Elseif Not isnumeric(c) then c.value= c & c end if Nect c See also IsArray, IsText, IsEmpty Peter
Yes use something like this For Each c in selection If isnumeric(c) then c.value= C*2 Elseif Not isnumeric(c) then c.value= c & c end if Nect c See also IsArray, IsText, IsEmpty Peter
D Don Guillett Dec 16, 2003 #4 This will select all cells on the worksheet with a number. Sub isitanumber() With ActiveSheet.UsedRange ..SpecialCells(xlConstants, xlNumbers).Select End With End Sub
This will select all cells on the worksheet with a number. Sub isitanumber() With ActiveSheet.UsedRange ..SpecialCells(xlConstants, xlNumbers).Select End With End Sub
