Hi,
I have been given an excel template.
This template gets populated with values in cells appropriately.
The task is that if a value is not present in a cell of a row then hide or delete that row. something like zero suppression.
I was thinking about setting the row height of that particular row to 0 in the load event.
If this is ok, then what is the code for this requirement please
row height
Hot Topic
- Office 97 / Windows 2000 Compatability
- Using arrows to select in drop down list in access
- How do I display my computer name?
- Coordinate of the mouse pointer in chart object client coordinates
- Creating MROUND function
- VBA Editor fails to start from Access 2003
- DAO can't connect to Access2007
- startup properties in Access
- How to color ligne in a listbox
- Access data to Excel workbook
Microsoft ISV
- Question: How do I hide the Title Bar?
- Hide/unhide
- MSDN Download
- Projects, objects & modules
- Capture Hyperlink values on open MS Access VBA
- How do I...
- Copy problem in excel, please help me.
- Applying one cell's formatting to another cell
- Problem with Query in VBA code : Object.CreateQuery()
- obtain data of next 10 days
row height
tamccann
Solved it as follows:
Dim i As Integer
i = 27
For Each c In Worksheets("Sheet1").Range("C27:C57").Cells
If IsEmpty(c.Value) = True Then
'Rows("43:43").RowHeight = 0
Rows(i & ":" & i).RowHeight = 0
End If
i = i + 1
Next