Dale's Take

Everything is open for discussion…

  • General
  • Social Policy
  • Psychology
  • Science & Tech
    • Mathematics
  • Programming
    • VBA – Excel
    • HTML / CSS / JS
    • PHP / WordPress
    • R for Statistics
    • MySQL
    • PowerShell
    • Git & github
  • Life
    • Employment
    • Trips
    • Events
    • Books
    • Movies
    • Self defense
    • Projects

VBA – Excel

Programming VBA - Excel 

VBA – Excel – Determine and set data range

November 4, 2021May 2, 2022 dradma 0 Comments excel, VBA

Use: Function LastRowInt(InWS As Worksheet) As Integer LastRowInt = InWS.UsedRange.Find(What:=”*”, After:=InWS.Cells(1, 1), Lookat:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row End Function Public

Read more
Excel Programming VBA - Excel Software 

VBA – Excel – Tips on Learning VBA

August 26, 2017September 16, 2017 dradma 0 Comments excel, VBA, lesson, programming

Every now and again I am asked what is the best method to learn VBA. On this topic here are

Read more
Programming VBA - Excel 

VBA – Excel – Count the Number of Matching Words in Two Strings

June 4, 2017 dradma 0 Comments excel, VBA, string, word count

Possibly useful to sort, order or compare lists of non-identical but related strings.

Read more
Programming VBA - Excel 

VBA – Excel – Routine to position shapes in range

February 17, 2017 dradma 0 Comments shapes, range, position, location, excel, VBA

Routine to position shapes in worksheet based on specified ranges. Note: Can use ‘print shape name‘ routine to create required

Read more
Programming VBA - Excel 

VBA – Excel – Print All Shape Names Routine

February 17, 2017 dradma 0 Comments excel, VBA, shapes

Routine to list names of shapes in specific worksheet or current workbook. Can make adjustments here to list various shape

Read more
Programming VBA - Excel 

VBA – Excel – Routine to Show All Worksheets (ie Make visible)

January 11, 2017February 16, 2017 dradma 0 Comments visible, excel, VBA, worksheets

When there are a lot of hidden worksheets, making them visible one by one can be a pain. Stick this

Read more
Programming VBA - Excel 

VBA – Excel – Reference list

January 9, 2017September 16, 2017 dradma 0 Comments

Great page on referencing pivot table ranges – shows the range selected for each selection method used http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=154:referencing-an-excel-pivot-table-range-using-vba&catid=79&Itemid=475 Excel Chart

Read more
Programming VBA - Excel 

VBA – Excel – Lookup Range

November 17, 2016January 17, 2017 dradma 0 Comments excel, VBA, lookup, function, index, match

Function to return a value for a specific id from a dataset with column headers in the first row (ie

Read more
Programming VBA - Excel 

VBA – Excel – Simple PivotTable Report

September 24, 2016February 16, 2017 dradma 0 Comments cache count, excel, VBA, pivottable, report

Simple PivotTable report to show basic information about PivotTables in the activework. Useful in tracking down lost PivotTables and other

Read more
Programming Mathematics VBA - Excel 

The Lost Boarding Pass puzzle

September 21, 2016November 17, 2016 dradma 0 Comments excel, VBA

The puzzle: One hundred passengers are about to board a plane. The first passenger lost his boarding pass and decides

Read more

Recent Posts

  • VBA – Excel – Determine and set data range
  • VBA – Excel – Tips on Learning VBA
  • VBA – Excel – Count the Number of Matching Words in Two Strings
  • VBA – Excel – Routine to position shapes in range
  • VBA – Excel – Print All Shape Names Routine
  • VBA – Excel – Routine to Show All Worksheets (ie Make visible)
  • VBA – Excel – Reference list
  • VBA – Excel – Lookup Range
  • VBA – Excel – Simple PivotTable Report
  • The Lost Boarding Pass puzzle

Recent Comments

    Categories

    • 3d printing
    • Books
    • Employment
    • Events
    • Excel
    • FreeCAD
    • General
    • Git & github
    • Javascript
    • Mathematics
    • MySQL
    • Philosophy
    • PHP
    • Politics
    • PowerShell
    • Programming
    • Projects
    • Psychology
    • R for Statistics
    • Science & Tech
    • Software
    • VBA – Excel
    • Web-tech – html/css/js
    • Wordpress

    Archives

    • February 2023
    • January 2023
    • December 2022
    • November 2022
    • July 2022
    • June 2022
    • May 2022
    • April 2022
    • February 2022
    • January 2022
    • December 2021
    • November 2021
    • October 2021
    • December 2020
    • February 2020
    • December 2019
    • November 2019
    • September 2019
    • July 2019
    • June 2019
    • April 2019
    • March 2019
    • September 2017
    • August 2017
    • June 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • September 2016
    • July 2013
    • May 2013
    • April 2013

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    Copyright © 2023 Dale's Take. All rights reserved.
    Theme: ColorMag by ThemeGrill. Powered by WordPress.