Macro

Delete all pictures in a selected range of cells Excel VBA

Delete all pictures in a selected range of cells Excel VBA The following program Deletes all pictures in a selected range of cells Excel VBA. Sub DeletePics() Dim PicRng As Range Dim Pic As Picture Dim Rng As Range Application.ScreenUpdating = False Set Rng = Range("B1:B100") For Each Pic In ActiveSheet.Pictures Set PicRng =...

Create new CSV file with copied data using Excel VBA

Create new CSV file with copied data using Excel VBA Create New CSV file with copied data  using Excel VBA from a macro file. Besides that,  the data transfer takes place to csv with copy paste program codes. Therefore, the following program generates csv file with copied data. Sub csv_gen() Dim wb_main As Workbook...

Range Selection in Excel VBA

Range Selection in Excel VBA Range(“A1:J70,T1:AB70”).Select The ranges are selected separately.   Range(“A1:J70″,”T1:AB70”).Select The range including middle ones are also selected.  

Export range or sheet to PDF in Excel VBA

Export sheet to PDF in Excel VBA ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "c:\Book1.pdf", Quality:= _ xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ OpenAfterPublish:=True Export Range in a sheet to PDF in Excel VBA Sheets("Sheet1").Range("A1:B1").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "c:\Book1.pdf", Quality:= _ xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _ OpenAfterPublish:=True  

Clear Non Printable Characters using Excel VBA

Clear Non Printable Characters using Excel VBA Sub CleanUpData()     Dim Ws As Worksheet     Dim Rng As Range, Cell As Range     Dim ArrCodes     Dim i As Long              Set Ws = ActiveSheet     On Error Resume Next     Set Rng = Ws.UsedRange.SpecialCells(xlConstants, xlNumbers + xlTextValues)     If Rng Is Nothing Then         Exit Sub     End If     On Error GoTo...

Published On

December 2018
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31