12-11-2019
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
12-11-2019
10:29 AM
I think this code should work:
Dim FilePath As String = "C:\Projects\testing.xlsx" Dim SheetName As String = "This_Sheet" Dim Column As String = "B" Dim Row As Integer = 3 GoExcel.Open(FilePath, SheetName) While Row < 99 GoExcel.CellValue(Column & Row) = "" 'Value Row = Row+1 End While GoExcel.Save GoExcel.Close
Should be easy enough for you to change the string values to look for the correct workbook.