How Many Rows and Columns Present in Excel ?

Ans : 

⚝ Excel 2003 Version :
☞ Total Rows = 65,000

☞ Total Columns = 255

⚝   Excel 2007+ Version :

☞ Total Rows = 10,48,576

☞ Total Columns = 16,384

---

Q ) Find Last Row & Last Column of Data Using VBA ?

Ans :

Sub LR_LC()
Dim Wks As Worksheet
Dim LastRow,LastColumn As Long

Set Wks = Thisworkbook.Sheets(Sheet1.Name)

LastRow = Wks.Range("A" & Rows. Count). End(XlUp).Row

'OR

LastRow = Wks.Cells(Rows.Count,1).End(XlUp).Row

LastColumn = Wks.Cells(1,Columns.Count).End(XlToLeft).Column
End Sub