Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
The same format is also used for finding the LastDataColumn, if needed.
Public Function LastDataRow() As Long Dim ExcelLastCell As Object, lLastRow As Long ActiveSheet.DisplayPageBreaks = False Set ExcelLastCell = ActiveSheet.Cells.SpecialCells(xlLastCell) lLastRow = ExcelLastCell.Row LastDataRow = lLastRow End Function
|Copy the value of Cell C5 into sheet2 Cell B5 if A1 on sheet 1 = (MCL). If cell C5 is empty (or 'No') do nothing. Is this possible?||7||25|
|Excel VBA User Form Help||21||26|
|Excel Charts: How is this Chart made?||8||24|
|mail (32 bit) not available for a user profile in windows 10||8||14|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!