I'd like to loop through each cell. However, I notice VBA loops through all my cells in a table from left to right, then down. Can I loop through each cell vertically instead?
I ask because...
I have a formula for Counting the amount of days between two dates however I need for the formula to count the days as well as the current date.
Here is the current formula: =DATEDIF(G4,...
I use a two-step process with my pivot tables. I have a table which is data-driven on one sheet. On the next sheet I have the actual pivot table. This is so I can program in my own switches an...
How can I create two stacked columns, from two different but related data on the same chart?
For example, this data would have two stacked columns for Light and two for Dark, one column for...
I have the below code in which I am attempting to run the computation on each cell in the column(except the last one). I am getting a Can't divide by 0 error and think it might be because of ...
I would like to create a desktop alert (pop up) when a certain criteria is met in excel. Understand i can do conditional formating, but you never know when it has been triggered unless you ar...
I'm running this code from Access 2003 on a PC with 2GB of RAM and 117GB free on the hard disk processing a worksheet with 38000 rows and 16 columns and getting Out of Memory Error -7 on the i...
A user copied an entire column from an excel spreadsheet into a new spreadsheet. Doing so, the original date format of the cells in the column (yyyy-mm-dd) came out as a standard text format ...
I understand David Brett (a.k.a. brettjd) wrote an excellent utility for removing duplicates within Excel. but his original web site is gone, does anyone know where I can get a copy of this ut...
Good afternoon,
I have used our CA to create a digital certificate to sign an Excel macro. The certificate is from a trusted CA and is set for 'Code Signing'. When I attempt to sign the mac...
Is there a way through VBA of updating a dynamic range to include visible rows only after using an Autofilter.
I have 200 rows of data in 7 columns, when I filter I show roughly 25, I would...
I have installed the 'excel 2007 analysis pack' (not the vba version) by going to Options --> Add Ins.
The 'analysis' pack now shows up in the "Active application add ins" section.
On the ...
I have an Excel 2003 spreadsheet with contains rows of records describing projects. The final column contains a "last-updated" value for the record which at the moment is updated manually. I n...
Hi
I am currently using a macro to export an excel form to csv using the code attached. The problem I am having is the data being exported inserts blank rows in the csv file due to the cells...
How can I hold a shif and go to the last row of data
Hi everyone.
I'm trying to convert an excessive redundant excel formula sheet to vba. This first step needed is to take the source data and in column 4 where all the trader books...
I would like to create a script that allows me to input up to 8 individual words in one column, and then generates all permutations from two words up to 8 words and all orderings as output int...
I have an Excel spreadsheet, I classify it in ascending order by any specific column, and I want to eliminate the duplicates (considering this specific column), but keeping the duplicate lines...
I'm a little stumped and would like some help.
Using VBA, how would I find the last cell used in a certain column that has data in it (disregarding formulas)?
Right now, I'm using this, ...
There is an Excel spreadsheet located in a shared folder on my work's network. The spreadsheet is used to record the hours that multiple engineers work on. The first worksheet is called "Sum...
Is it possible to run an Access macro inside of excel using an ado connection?
Is there a way to count cells highlighted or sum cells highlighted?
Currently I am running VBA code that is saving the Active Workbook, however, in 2007, Microsoft put a Compatibility Checker in place. In normal mode, you can click on the check box to unselec...
Hi experts,
I have an excel workbook, that has sheet1 and sheet2:
I require to read the 3 cells (A1, B1, C1) from sheet1 and insert them in sheet2. This requires inserting them as new rows a...
I have a time calculation in my spreadsheet (=C2-B2) to determine the number of minutes between a start and end time. I have cell D2 displayed at 'Time' (13:30) so that I can see the hours and...
