mubi_masti
New member
- Joined
- Oct 8, 2011
- Messages
- 14
- Reaction score
- 0
- Points
- 0
I am using following code to format the excel sheet from access.
With xlApp
.Application.Sheets(sSheet).Select
.Application.Cells.Select
.Application.Selection.ClearFormats
.Application.Rows("1:1").Select
in first row only five cells have values and instead of selecting whole row i want to apply formatting on only those cells that have values. For this i need to give range to following method. Is it possible excel autometically identify the range and apply formatting.
.Application.Rows("1:1").Select
like following
.Application.Rows("a1:a5").Select
With xlApp
.Application.Sheets(sSheet).Select
.Application.Cells.Select
.Application.Selection.ClearFormats
.Application.Rows("1:1").Select
in first row only five cells have values and instead of selecting whole row i want to apply formatting on only those cells that have values. For this i need to give range to following method. Is it possible excel autometically identify the range and apply formatting.
.Application.Rows("1:1").Select
like following
.Application.Rows("a1:a5").Select