Skip to content
Macrostash
  • Excel
    • How to use a Vlookup
    • VBA
  • Access
    • SQL
  • PHP
    • JQuery

Tag: columns

Excel – VBA to Select Columns in VBA with Numbers instead of Letters

Posted on November 5, 2011by admin

So say you want to select a couple columns through a loop and you need to be able to iterate through columns numerically; so you would need to select a range numerically. Here’s the simple way: Columns(“A:B”).Select Range(Columns(1), Columns(2)).Select

Categories Excel VBATags columns vba

Ads




Recent Posts

  • Comparison of Javascript Geocoding API
  • Tips for Writing a WordPress Plug-in With URL Rewrites
  • DNS Speed Increases on CloudFlare Free DNS
  • How to insert inline Javascript in WordPress Block with Gutenberg Editor
Proudly powered by WordPress