Team,
I have currently built a report for senior management by which information from Excels workbook is copied to MS Office using VBA. The whole report works except for this ridiculous mil...
Hello,
I have cells that have data like this:
37:13:00
but I if I highlight the cell in the top bar in excel it shows the cell's contents as this:
1/1/1900 1:13:00 PM
if I copy and past...
I have an excel document with multiple sheets. I want a script or program that will remove duplicate rows within a sheet, and also if possible, give me a list of rows that are listed in more t...
Hello,
I have the following code which I would like to auto update a number of links when opening the work book. I would like the user not to be asked to update existing links.
At the m...
Hi experts,
I am creating a macro to display a list of document numbers based on the transaction code selected from a combo box. The list is displayed on the same sheet (Sheet1).
For ea...
Hi Experts,
What is the Excel VBA to find a value in a cell and return the row and column of that cell?
Thanks
Our lab uses Macs and PCs. Excel gives correct r^2 values on the PC. When someone puts the data into the template on the mac, it gives bad r^2 values (most obvious are negative r^2 - this sh...
I am interested in programatically selecting an entire row in Excel, so that it is clear that it is selected. It is important that when a user types to edit, the originally clicked cell is the...
I have this line of code and get the error message"Object Variable or with Block Variable not Set" what have I done incorrectly.
Set NewRng = Range(rgToUse, rgToUse.End(xlToRight)) 'Comment...
This project is very urgent, so I would appreciate it if some of you experts out there can figure it out quickly, thanks!
I would like to create a control button that would have the simila...
Hi folks
say we have at least two sheets in a book, one called costs, and one called quote.
i am in say costs!a5
i want to see if in sheet quote in column x is there a value equal to row()...
Hi
The user must select from a data vbalidation list in Cell F4.
What they choose then determines the next data validation list.
The IF statement I am using is:
=IF(F4="Uni Hospital ...
Hi:
Is there an easy way to convert month names, say 'Jan', to 1 and 'Dec' to 12?
On a worksheet I have a ComboBox where users could chose a month and then a cell where users could key ...
I can't figure out how to format the formula to use RC notation, so that an existing column of text entries can be formated based on the contents of an existing cell set of one to the right.
Here is what I'm trying to accomplish with ADO connections:
In excel, user clicks button:
1) open access database "DPS.mdb
2) run macro name "DPSfile" in access
3) query named "DPS#3: ...
I am trying to populate a textbox (or a callout will do fine too) with
text picked up from a cell (say cell A1).
It was working sometimes and not working sometimes. I discovered the hard...
Experts,
How are you doing?
I have many reports which I run that have pivot tables to break-down the data into usable pieces of information. The problem is, at any given time, I might ha...
Has someone developed an excel VBA module where a prompt box shows the files in a directory (From the root such as C:\) and allows one to navigate thru the different folders and select a file...
Hi,
Excel file too large takes long time to open,save etc.Can all the macros be saved some where and i should be able to run them when required.
Can i have all macros in some folder.When r...
In Excel. I'm trying to perform two calculations.
The first calculation is the difference between two times: start time and end time. This column is in the datetime formatting and list...
I've got several controls (buttons, checkbox, drop-down menus etc.) on a sheet which were all working well. At some point in development of the VBA, I started getting the following message and...
I'm not sure if I should be using the trend or forecast function in Excel or maybe even something different all together.
I have a data set for each week of 2005 and I would like to extrapo...
Is there a way to insert a formula inside a text box within an Excel graph? For example, lets say at the bottom of my bar chart, I want to insert a formula (that calculates a result from else...
I'm trying to put together a cell formula that will look through a range of cells and puts them together in a list.
The twist is that I want to put a hard return after each value in the li...
What have I done wrong with the following code snipet. I am trying to set the range ("B:B") to a variable named release.
