Search results

Hi I need to delete all rows if if the cell in U column is blank. Sub a() Worksheets("Testing Execution Data").Select For i = 15 To 100 If Cells(i, 21).Value = "" Then Cells(i, 21).Select Rows(ActiveCell.Row).Select Selection.Delete Shift:=xlUp End If Next End Sub But it is...

Hi I have a chart in a sheet and data in other sheet. The data range may vary then and there. Data: B2 to Q3 (sheetname: Test Execution Data) chart name: Chart 1 (sheetname: Dashboard) Problem: If I have no data in column Q, then the legend color should not be shown in chart. But it is...

Hi, How to revert changes after running a macro?

Hi, I have an user form (similar to find & Replace functionality), when the form is running, I want to edit cells in worksheet. How this can be achieved?

Hi, In the review phase, I would like to get list of incorrectly spelled words in a sheet with its cell address. Output Sheet: 1. taht A2 2. tesign A9 etc Is that possible?

Hi, I have a huge data sheet where I have many columns. And I want unique values of column 'D' should be listed Row wise in another sheet. Sample data sheet: COLUMN A B ROW 1 123 abcd ROW 2 223 aDcd ROW 3 323 aFcd ROW 4 423 aFcd ROW 5 523 abcd OUTPUT IN SUMMARY SHEET...

Hi, How to create hyperlink (to other cell in other sheet) in a single go? In 'find and Replace', if we replace 'Temp01' to 'A20', It will change. Is there any similar way to 'Find and Hyperlink'

Hi, I am surprised when I tried to replace few bulletin points (asterisks), all the characters in the particular worksheet have been changed. Just curious to know why it is considering all characters as * and Is there any way to replace only the * alone?

Hi, I have an XLSM file(6 user forms & 3 modules, file size: < 250 KB). Whenever I open it is taking 30 seconds to load than other excel files. Is there any way to reduce the load time? PS: When workbook open, I am calling 'Userfrm.show()' alone.

Hi, I have a common sheet named 'Summary' and in that, I have all other sheets name for some calculations. If the user adds a new sheet then the new sheet name should be added to the summary sheet. I need formula only and not macro. Please help. - Dhamo

Hi, I have written few codes which will be used by all my team mates. And I would like to give the code as addin(xla) with ribbon options. So that, after installing that add-in whenever they can use in a single click. I have around 7 different codes, I need 7 new buttons with button...

Hi there, I have a workbook with summary sheet and day sheets. Daily I will add one sheet. And I need that sheet name should be added automatically to summary sheet. If I add a sheet named '01-Feb-2013', then the sheet name should be added in "a1" of the summary sheet. And When I add...

Hi, I'm trying create a user form which will display difference of two dates. The dates should be selected from calendar icon from uesrform. Does anybody have sample file with calendar control in userform?

Hi, I have a table with 3 columns as in the below table. When I run a macro I need to get the sum of units based on the date for the names. See output table for your reference. Name | Date | Units AAAA | 1/1/13| 9.0 BBBB | 1/1/13| 8.0 AAAA | 1/1/13| 5.0 AAAA | 2/1/13| 6.0...

Hi, I am having a pivot table in my workbook, when I run a macro the data source(sheet1) of pivot table (PT) will be updated. Modules is the row label, status is the column label. Whenever I refresh the pivot table,(after macro run) the modules and status will be changed. I want to keep the...

Hi, I would like to set data source for my pivot table in run time based on used range in sheet 1. Please help

Hi, My requirement is to add percentages with two decimal points in other cell by formula (Not by macro) when values changes in other cells. Eg. Input: Al: 5, B1: 10 Expected output: C1: 5/10 : 50.00% Actual Output: C1: 5/10 : 50% Formula: =A1&"/"&B1&" : "&(A1/B1)*100&"%" But when...

Hi, I have an xlsm file consisting of an user form. When I open the workbook, the user form will be shown and backside the workbook is displaying by default. (The user form height : 294, width:397.) Is there any code to hide the workbook? If not, is there any option to re-size the excel...

Hi, I have a Pivot table (PT) and I will clear all missing items in the PT by the below code. But I want to clear only row labels and not the column labels. Sub DeleteMissingItems2002All() Dim pt As PivotTable Dim ws As Worksheet Dim pc As PivotCache For Each ws In...

Hi, How to prevent the user to see the code apart from this option. VBA Project Properties - Protection - Lock for viewing. I know it is very strong, but still there are chances to break this code. Thanks,

Hi, In my user form, i ll get input of file name from the user, and i prevented typing ambitious characters (*<>/). I added code, when textbox value is changed the code will check the key pressed is any of these spl char, it will check the ascii values and will not allow the value to...

Hi, I have a browse button in my userform. And it will return folderpath(destination folder). but I need to verify whether I have access to create the file in the selected folder. Please help.!!

Hi, Consider in a workbook, I have 3 or more sheets in date format (Jan-05-2012,Jan-06-2012,Jan-07-201 and ..)along with a summary sheet. And in every date sheet, i have two or more names (name 1, name 3 and ...). And each name has one value in a day sheet. Day1 sheet eg: Names -- Tasks...

Hi, I have a pivot table in sheet1 of a workbook. And the source data is from sheet2 (with 5 columns, 5th column is date and the column format is "mm/dd/yyyy"). But whenever I refresh the pivot table, i want the format should be mm/dd/yyyy. but based on date the filter value is showing as...

How do I add an icon in user form's title bar? Is it possible?