Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am quite new to VBA.
I have a range O5:O21 called "thisarea" which is not always full. Using Sub test() Dim rascal As Range For Each rascal In Range("thisarea") With Sheets("front page") .Range("a2").Value = rascal.Value .Calculate MsgBox rascal.Value End With Next rascal End Sub I would like this to return only 'full cells' (the cells will always have a formular in them) I know offset will work but I am having a bad day and can't work it out Help please Matthew |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm not sure how offset fits in here, but if you wanted to look at the cells in
ThisArea that don't evaluate to "" (looking empty): Sub test() Dim rascal As Range For Each rascal In Range("thisarea").cells With Sheets("front page") if rascal.value = "" then 'skip it else .Range("a2").Value = rascal.Value .Calculate MsgBox rascal.Value end if End With Next rascal End Sub If you wanted to avoid the cells that are really empty--no values, no formulas: Sub test() Dim rascal As Range For Each rascal In Range("thisarea").cells With Sheets("front page") if isempty(rascal.value) then 'skip it else .Range("a2").Value = rascal.Value .Calculate MsgBox rascal.Value end if End With Next rascal End Sub Matthew wrote: I am quite new to VBA. I have a range O5:O21 called "thisarea" which is not always full. Using Sub test() Dim rascal As Range For Each rascal In Range("thisarea") With Sheets("front page") .Range("a2").Value = rascal.Value .Calculate MsgBox rascal.Value End With Next rascal End Sub I would like this to return only 'full cells' (the cells will always have a formular in them) I know offset will work but I am having a bad day and can't work it out Help please Matthew -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Offset | Excel Discussion (Misc queries) | |||
Offset Help | Excel Worksheet Functions | |||
OFFSET HELP | Excel Worksheet Functions | |||
Offset | Excel Worksheet Functions | |||
SUM(OFFSET)? | Excel Worksheet Functions |