Selection.Replace What:=rc, Replacement:='' Rc = InputBox('characters', 'Enter your Value') Macro code Removing a character from selection in excel This code will check the Range of selected cells and convert it into uppercase text when run. 'We are checking the each cell value if the cell value equals today's date. 'Assigning the last row value to the variable lRow 'Declaring the variable iCntr as long to use in the For loop 'Declaring the variable lRow as long to store the last row number Starting program and sub procedure to write VBA code to delete rows based on date. This code enables you to convert your chart to an image.

MsgBox 'Your Pivot Table is now updated.'ĭepending on preference, sometimes you may need your chart as an image. Pivot_Sheet.PivotTables(PivotName).RefreshTable PivotCaches.Create(SourceType:=xlDatabase, SourceData:=NewRange) 'Change Pivot Table Data Source Range Address NewRange = Data_Sheet.Name & '!' & DataRange.Address(ReferenceStyle:=xlR1C1) Set DataRange = Data_Sheet.Range(StartPoint, Cells(DownCell, LastCol)) LastCol = StartPoint.End(xlToRight).Column Set Pivot_Sheet = ThisWorkbook.Worksheets('Pivot3') Set Data_Sheet = ThisWorkbook.Worksheets('PivotTableData3')

The columns will be added after the selected cell. When it is run, you will feed the number of columns you are interested in, then click ok. This code gives you the option of inserting multiple columns. In the dialog box, select the macro you want to run.īelow is a list of Macro codes to enable you to get started Insert multiple columns

Macro code Removing a character from selection in excelģ.

Automatically insert the date and time stamp in the adjacent cells.

How to enable macros in excel sheet