Map of southeast asia with countries and capitals
Hello, I'm trying to create a macro code to sort a data in a workbook for the current sheet. When I use the macro recorder, it gives the tab name of the workbook but because of other routines done to Creating a named range allows you to refer to a cell or group of cells with a custom name instead of the usual column/row reference. The HUGE benefit to using Named Ranges is it adds the ability to describe the data inside your cells. Apr 18, 2013 · In VBA-Excel, UsedRange is very effective property when it comes to deal with the excel file which contains data. Right from formatting options of excel sheet to copy pasting the data, getting informations about rows or columns or clearing the data from excel. Feb 10, 2011 · Hi guys, Made my 1st post here last night and you were all very helpfull, so hoping for more of the same I've found a few threads similar to what Im asking for, but none exactly, and none I've been able to amend to suit my needs (I'm VERY MUCH a VBA novice).