I need a piece of code in Excel that if the user enters the character "." (a full stop) in the field range B8:B40 it throws an error and removes the input. I cannot use data validation or fo...
Say I have two sheets in an excel workbook - sheet1 and sheet2
On sheet1 there is a named range (SomeTotals) which is cells B10:D10 (3 cells in a row)
On sheet2 I would like display the cont...
We have a macro in excel file to email information from the worksheet and Id like reduce the email size. Looking for the way to send a text instead of excel format cells.
Have to send the d...
See Attached. In cell AI2 I need to sum the AI column. However for each row that has a name followed by a "*" it should add 1.25 instead of 1. i would like the cells to still show just a 1....
I have a PivotTable and PivotChart I'm trying to add a ComboBox to allow a user to select a date range by Quarter to display.
The date data is in the format "2009-11" for November '09. I n...
I need to build a User Defined Function that can tell what row it is on and access the contents of other specified cells on that same row. I don't know how to reference the current row or the...
Hi experts,
Is it possible to have a screenwide crosshair cursor in my excel sheet?
I mean a line from left to right and from top to bottom.
thanks
Can I have my Excel font size drop-down box include sizes less than 8 . Id rather have the smaller sizes in my drop-down list than the larger sizes. Is there a way to update the font size...
Folks,
I'm automating Excel in .net. The OM has an Application.RegisterXLL method, which I call to register my XLLs. However, once registered, I can't figure out how to unregister them. ...
Hi,
I am trying to write code which will concatenate the data in row a1 lets say with rows a2 through a8 and continue down the column concatenating every 9th row with the rows below it. Be...
EE Excel Experts:
I need a simple macro that will
1. Establish an integer counter with starting value of zero.
2. Iterate through Cell B3 through to the last row in column B that has a no...
The attached file shows a chart in Excel that changes when the source data is filtered. The chart reads a range that gives the Subtotal of each column. This is causing an error though becaus...
Hello,
In Excel 2007, (not using a converted Excel 2003 worksheet, but a fresh Excel 2007... all the way worksheet)
1) How do you configure the Pivot Table to only show the Top 10?
2) Ho...
I need to retrieve data in Excel from a web site. This is the URL: http://nseindia.com/marketinfo/companyinfo/companysearch.jsp?cons=tatapower§ion=7
On executing this web query only table...
I have some code that creates an Excel workbook with multiple sheets. A certain number of the sheets added is determined by the following code:
Set rsTab = CurrentDb.OpenRecordset("select ...
Everything I have looked at to freeze panes using VBA has pointed to something like this:
Range("A5").Select
ActiveWindow.FreezePanes = True
Within my Sub, I have opened the Excel appli...
Friends,
Please, how can I get this to work?
It seems it doesn't recognize the variable within Worksheets().
Thank you all for your attention.
brunces
I currently have 3 columns in a Excel spreadsheet. In column A is a IP Address (each one is different). In column B there is a URL (each one is different). In Column C is the hyperlink to the ...
I am trying to open an Excel file within Access 2007 VBA. I have done this before and it worked fine. The statements I am using to do this are below. When I debug and step through the program,...
I have several ranges of cells in my spreadsheets that have data in the following pattern; x.xxxxxxxxx. I need to delete everything after the 5th character. These are all numbers, but someti...
MS Excel allows comments to be inserted in cells which leave a red tag to indicate that a comment is there, but are otherwise visible only when the cursor hovers on the cell. Is there any way ...
I've got an Excel worksheet I'm trying to add SQL Queries to that get values from different drop-down selectors.
I have the macro below in a Module and it works fine, but only when I run th...
I use Office XP. I have problem when I open the attachment from outlook. The excel file won't open. The excel application launch but just shows a blank screen. If I then click file > Open, di...
I have an office that has 10 administrative users and a small retail showroom With 3 sales people. I would like to be able to have my sales people be able to fill out an Invoice in MS Excel an...
Hello, I'm using Excel 2007 to create a workbook connection to an Oracle database. The tables in the database are HUGE so i need to use a SQL statement to select data within a range. As such ...
