I have asked before to no answer, but there must be a way to set excel to NOT format fields to exponential format.
I know I can do it by hand everytime I load a file but that is ridiculous ...
every time that I turn on mi PC a process EXCEL.EXE appear between the process running, note that I didn't open de MS Excel application. Could this be a virus?
Hi.
I've attached a very simple spreadsheet to illustrate my problem.
The transaction lists are dynamic should be considered dynamic. I don't know before hand who the people are, how man...
how i can write code in excel vbeditor for open two files and merge the files
I have an Excel Area chart with 8 SeriesCollection's in it. When I change the last SeriesCollection to xlLineMarkers using ApplyCustomType, the legend item for this collection drops from the ...
I have a user form search_data that when you enter the customer name and press OK all the information present in the table on the worksheet.
The problem I have is that the customer will app...
Hello
I have a simple question but it is very urgent.
I have a spreadsheet in wich I do some calculations (using if-sentences) these calculations then return me some numbers in cells J9 an...
Using Excel 2007 and VB.NET I'd like to know what the code would be in the Sheet change event to change to color of only certain columns in a row based on an input of a field in that row. In t...
I have an excel spreadsheet that has a list combo box for each column at the top. whenever we sort on any of the columns using the list feature, some of the formulas references change while o...
Hi - I am tracking the meetings held by many committees in one spreadsheet.
Committee names are in Row 1 and the date of each meeting in Row 2. I calculated the recurring meeting dates f...
I have hundreds of data sets showing change (y) over time (t) at different locations. I am attempting to plot the (y,t) data for each location and fit a second order polynomial line of regres...
Hi Guys,
I need to set up a progress Bar for this Macro. I am a newbie to VBA. Could someone please help me getting it done..
Cheers
Costa
A related question: is there a way to format entire rows of a spreadsheet such that if the value or text of a cell is different than the cell above (simple example: if a2=a1, then the row is t...
I would like to create a pivot table from an ODC connection that references a report on a Microsoft Dynamics CRM 4 server. I've been able to create an ODC that connects to other resources on ...
I need to make a list that will allow the user to select from the list of options, but if their option is not available they can then type in the box the option they need. I cannot figure thi...
I have a column which is nested between 2 columns. The middle column contains the =EXACT() statement and show either TRUE or FALSE comparing the cells on either side.
How do I have the cel...
I need to enter info into an ACCESS userform. I do not have access to the code in ACCESS.
I have been using SENDKEYS (ofcourse we all know how well this works....)
I am wondering if there is...
I have an Excel 2003 Spreadsheet that contains about 50 variables/columns. The variables are repeated for each row; each row just has different values for the variables.
I need to loop th...
