How to convert Columnar Data Range in UPPERCASE using VBA and not formulas?
In a Table I
need to have certain Columns of Data in UPPER case, so how do I do the same for existing data , I know about the UPPER
function but I want to convert the data which is already there with a Macro.
Also, need some suggestions on using
the COUNTA function in VBA..I will be copying data from an Company Application in Excel..
I need to make this Data
look neater with BORDERS only till the last filled Row and the remaining portion will not have any GRIDLINES..
am doing this right now, as am sill no good in VBA but applying the Functional approach..
Dim DataRng As String
DataRng = "2:" & WorksheetFunction.CountA(Range("B:B"))
BorderRng ="A1:M" &WorksheetFunction.CountA(Range("B:B"))
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
'=====The code for geting Borders=====
This works, however the approach is not VBA oriented so can someone also help me on this as well as getting an Entire Column
This somehow does not work