Repeating same task for different cell
Hi All ,
I need to repeat the below task at different cell . E.g C8 ,D20 , C21 ... Dim sRange As String sRange = "C8" Range(sRange).Select If IsEmpty(ActiveCell) = True Then ?.. Else ?? End If Would appreciate someone can help , thanks. -- Message posted via http://www.officekb.com |
modify this script to a function as follows
Private Function modval(row,column) Dim sRange As String sRange = worksheets("your worksheet name").cells(row,column) Range(sRange).Select If IsEmpty(ActiveCell) = True Then ?.. Else ?? End If Then in the cell you put value which is to be manipulated just pass the row and column to this function like =modval(8,3) for cell c8 vikrant "Tan Arthur via OfficeKB.com" wrote: Hi All , I need to repeat the below task at different cell . E.g C8 ,D20 , C21 ... Dim sRange As String sRange = "C8" Range(sRange).Select If IsEmpty(ActiveCell) = True Then ?.. Else ?? End If Would appreciate someone can help , thanks. -- Message posted via http://www.officekb.com |
How will you determine which cells?
If in advance, here's one way: Public Sub test1() Dim rCell As Range For Each rCell In Range("C8,D20,C21") If IsEmpty(rCell.Value) Then '?.. Else '?? End If Next rCell End Sub If you want it to run on all selected cells: Public Sub test2() Dim rCell As Range If TypeName(Selection) = "Range" Then For Each rCell In Selection If IsEmpty(rCell.Value) Then '?.. Else '?? End If Next rCell End If End Sub Note that selection/activation is not necessary. Using the range objects directly makes your code smaller, faster, and IMO, easier to maintain. In article , "Tan Arthur via OfficeKB.com" wrote: I need to repeat the below task at different cell . E.g C8 ,D20 , C21 ... Dim sRange As String sRange = "C8" Range(sRange).Select If IsEmpty(ActiveCell) = True Then ?.. Else ?? End If |
|
All times are GMT +1. The time now is 01:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com