Skip to content
Xlttn.com
  • Sheet Management
    • Range Selection
    • Protection Test
    • Cell Analysis
    • Data Extraction
      • Text Extraction
    • Workbook Access
    • CSV Import
    • Excel Integration
    • Sheet Analysis
      • Range Analysis
    • Guid Creation
    • Column Row Info
    • String Analysis
  • Functions
    • Row Deletion
    • Data Cleaning
    • Date Calculation
    • User Controls
      • Control Loops
  • Table Management
    • Table Looping
  • Workbook Security
    • Code Security
    • VBA Protection
    • Save Options
  • Formula
    • Formula Usage
    • Function Examples
    • Number Formatting
    • Boolean Input
    • Data Display
  • VBA
    • Text Input
    • Break Removal
    • Page Management
    • User Interaction
    • Inputbox Usage
    • Range Input

Column Row Info

Get Column Letter And Row Number From Both Parts Of A Range

November 28, 2023 by xlttn team

less than 1 minute read Here are some basic methods to get a Column Letter & Row Number from both parts of a Range ie. “A1:B2”. The examples below will result in Column “A”, Row “1”, Column “B” & Row “2”. This can be very useful when building dynamic Ranges: ‘ // select a Range … Read more

Categories Column Row Info, Range Analysis

Recent Posts

  • Adding a Context Menu to a Userform’s Textbox
  • Benefits of Bulk Email Marketing
  • Export and Save Selected Sheets to a New Workbook
  • Hyperlink Using the Hyperlink Formula With Vba
  • Copy Visible Range To A New Workbook
  • Home
  • About us
  • Write for Us
  • Privacy Policy
  • Affiliate Disclosure
  • Terms & Conditions
  • Disclaimer
  • Contact Us
© 2025 GeneratePress