Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to show all values
Hi, I have a sheet with the following structure ' A B C <-- Columns /START/ 1 2 3 4 5 6 7 8 9 10 11 /END/ Rows = 2 to n Columns = 2 to n I need a function to show each element in the sheet, somthing like CellStart = A1 CellEnd = A55... CellTemp = CellStart While CellTemp < CelEnd if Worksheets(1).Range(CellTemp).Value < null then MsgBox Worksheets(1).Range(CellTemp).Value end if move to the next value (maybe down, maybe left) CellTemp = CellTemp + 1 row Wend |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to show all values
Check your other post.
AlejandroArias wrote: Hi, I have a sheet with the following structure ' A B C <-- Columns /START/ 1 2 3 4 5 6 7 8 9 10 11 /END/ Rows = 2 to n Columns = 2 to n I need a function to show each element in the sheet, somthing like CellStart = A1 CellEnd = A55... CellTemp = CellStart While CellTemp < CelEnd if Worksheets(1).Range(CellTemp).Value < null then MsgBox Worksheets(1).Range(CellTemp).Value end if move to the next value (maybe down, maybe left) CellTemp = CellTemp + 1 row Wend -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
Function to show all values | Excel Discussion (Misc queries) | |||
one column of cells show ####. Values show when I open it. Help | Excel Discussion (Misc queries) | |||
Show Top 3 Values | Excel Worksheet Functions | |||
Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ? | Excel Programming |