I'm trying to open an excel spreadsheet but when I open it I get the file name.csv is locked for editing by 'another user'. Open 'Read-Only or click 'Notify' to open read-only and receive not...
I have mutliple macros running and everything works well - I just want the exported text files to remove the unwanted quotes that are added when it sees a comma in the field or a quote.
Mic...
How would I change this macro to select everything other than "Tax" and delete those rows.
Right now its set to delete all rows with "Lunch" for the subject.
Sub KillB()
'This macro was wri...
Hi,
I have number of cells filled with text. The content of all cell have one common property - the text in each cell contains the symbol dot "." .On both sides of the dot symbol there are ...
Hi,
I have two worksheets. One of them I am going to use to enter data from a some software I use. The second worksheet I would like to have the data from the first worksheet transferred to...
Greetings,
I have 9 workbooks with 10+ sheets (worksheet names are "App #") that I want to cycle through and copy one column "F" from row 4 to 166 and paste special transpose into a separat...
How can I embed a calendar into Excel? To explain further, I would like a calendar to appear when I click on a specific cell, so I can then click on the date to fill the Excel cell. Any though...
I am trying to write some VBA code in the built-in VBA editor in Excel 2003. A strange thing keeps happening. As I am typing out code, the editor autmatically removes the last space that I typ...
I have the following data in Excel
26 27 28 29
a 3 4 0 0
b 0 2 0 0
c 0 0 4 0
d 0 0 3 4
e 0 0 0 0
I graph this using 2D Stacked Bar and added labels to each category. The problem is ...
Need a macro that will copy cut and paste with (cut mode of and screen updating off) the data from B5:BA95 (worksheet - Pricing Summary).
If the list grows beyond row 95 then allow for t...
In a nutshell: I'm loading an Excel file from VB .NET 2008 using the Interop COM and although I'm able to access the cells and their values, I would like to:
1) add a new button to the Excel ...
Hi Everyone-
I am working with excel files that have many many worksheets in each one. Is there some VBA script that I can use that will:
1) Create a new worksheet
2) List of the...
HI,
I have a range from L4 to T4. Each row in that range contains has one cell with a number in it. I need to prefix only that cell with 'AC' and leave all other cells blank. If the cell...
I have a VBA macro that reads two cells that contains 2 time (h:mm). I will then call a time difference function to calculate the difference between the two time (h:mm). Then call another func...
Hi Experts
I have enabled protection on a excel worksheet mainly so the tabs to move a number of cells to the next input field.
I am getting the following error now when I input some infor...
How can I restrict column addition/deletion between column K and L. At the same time I would like to restrict row addition/deletion between line 1 and 388. What would be code ? Thanks
I am working on a vb script (.vbs) for a user to open a Microsoft Access project file (.adp) on their desktop. It checks to see if there is a newer version of the file on the server. If ther...
Hi all experts.
I have a macro that is designed to copy cells based on a cell value. I need help to select the range of what needs to be copied. Now it only copies content from column "F". ...
I have a workbook where I am using a number of Sumproduct calculations to tabulate different metrics (20) for operations. Each metric is in it's own column with a field name. The sheet allow...
Is it possible to open a text file with long text (more that 255 characters) or multiline text in Excel?
I want to pull text from a database and put it into an Excel spreadsheet. But the...
Attached is some code that I've been using to create a reverse pivot. At the moment it only does 3 columns, but I need it to add an additional column that includes the DeptID (Sheet Tab or Sh...
I want to set a default value, 1 to a cell. If user enters any value greater than 1, then it accepts that value. But if the user enters 0 or deletes the '1' and leaves the cell blank, the cell...
Hi Experts,
Looking for the cleanest vba code to copy a range, let's say A1:F1 from sheets(1) to sheets(2). Ideally, it should be one line.
Loop or copy/paste not ok.
Thanks,
T...
Hi,
I created the following SUMIF formula to reference a column in a data range that changes based on the value of a cell. For example, the data range contains columns that reference quart...
Good Morning Experts,
I have a formula for about 250 cells per worksheet and over 50 worksheets. The current formula is:
=SUMIFS(Amounts[September],DEPT_ID,"G1500",UTHSCSA_EXP,$A13)
...
