If you read my latest update on how we can get position of last row containing data, then most probably you already have a glimpse on how we perform the same task with last column containing data in Excel.
The VBA code is the exact replica of the code to get the last row, only this time, we change the row into column.
Function LastColumn() As Long Dim ix As Long ix = ActiveSheet.UsedRange.Column - 1 + ActiveSheet.UsedRange.Columns.Count LastColumn = ix End Function
The function above will return the appropriate position of the column even when the last column containing data in a hidden state.
The results of this function is the column number, not the column name (1 for A, 2 for B, etc). If what we need is the column name, then we can use the excel column number to column name converter that I wrote before.
Pingback: scary games
Pingback: cctv installers
Pingback: scrapebox list
Pingback: Unusual Naruto Itachi Uchiha Mangekyou Sharingan Contact Lenses
Pingback: hublot swiss replicas
Pingback: office supplies & equipment
Pingback: archiwizacja danych
Pingback: cakes
Pingback: Cisco 3845
Pingback: tacos mexican food
Pingback: emlak yaz?l?m?
Pingback: gifts idea
Pingback: cash book
Pingback: address
Pingback: the best electric chainsaw
Pingback: tucker hill mckinney texas
Pingback: fun times
Pingback: kitchenaid kfp750
Pingback: Juegos de futbol 2013
Pingback: natural health
Pingback: kid picture
Pingback: plastic snow fence
Pingback: Software
Pingback: buy list
Pingback: cooking career
Pingback: Win Ipad3
Pingback: naprawa dukarek HP
Pingback: used sub-zero 36 refrigerator for sale
Pingback: oil stock
Pingback: Immobilier Quimper
Pingback: ideas home business
Pingback: ulta printable coupons
Pingback: become a beach body coach
Pingback: replica watches
Pingback: payday loans
Pingback: link
Pingback: click here
Pingback: gogo games
Pingback: official site
Pingback: payday cash loans discussions
Pingback: tv live
Pingback: dental practice brokers discussions
Pingback: servis char
Pingback: norcross tree removal
Pingback: HCG Diet Reviews
Pingback: life coach websites
Pingback: workers compensation requirements