Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Function FindRangeRowColumn(UsedRng As Range) As Range Dim Firstrow As Long, lastrow As Long, firstCol As Long, LastCol As Long, strFirstCell As String, strLastCell As String Set UsedRng = ActiveSheet.UsedRange Firstrow = UsedRng(1).Row firstCol = UsedRng(1).Column lastrow = UsedRng(UsedRng.Cells.Count).Row LastCol = UsedRng(UsedRng.Cells.Count).Column 'returns column name instead of column letter strFirstCell = Cells(Firstrow, firstCol) 'returns column name instead of column letter strLastCell = Cells(lastrow, LastCol)
|Excel - Clone tables or sheet to another work book.||19||60|
|25th of every month||7||38|
|How to select a random percentage of a spreadsheet to remove for sample||9||25|
|Protecting an object||3||26|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!