I have a worksheet Named "NNA". In column B there are only three possible selections:
1) 100% Company A
2) 100% Company B
3) 100% Other
Based on what is entered in Column B I want AF to ...
Dear Expert,
I want to write a code to change a column of data (some text, some numeric) into all text or data, what is the VBA formula or code to use?
Hi, just started to use excel 2007. I use ',' as decimal separator, 2 decimals and '.' as tousand sep. in international settings.
I want to replace comma with dot in pricelist, like 1234,567...
I have a data that i want to view in an Excel Pivot Table. The Row & Column Labels are not a problem - but the data field is. I want to display text in that field and not a calculation. How do...
Experts,
The code below seems to work fine but errors out on line 12; it wont exit. Just need an expert pointer on setting this up.
Peter
how do I make a pivot table automatically refresh any time there is new information using a Macro?
Hi
My question is in three related parts, trust that is OK.
I am updating two textbox values in VBA code and want to refresh the displayed textboxes before popping up a message telling t...
I have a worksheet with over 17,000 records(in rows) and maybe 35 or so columns. I need to do an error check to make sure that the correct types and correct values are in each column. I real...
Experts--
I have a protected worksheet that I need to provide a method to sort the records. I have created a user form with associated buttons&.but I know that there must be a more efficient...
Hi
In Excel VBA what is Debug.Print used for
Hi All
Below attached is my VBA script.
I want to copy the filtered data to a new sheet. instead of selecting the whole sheet. I need a sub that only select the data until the empty cel...
Hello all.
I am having trouble with the code below. In essence I want to hide certain rows, which are based on multiple cell values (in same row). The worksheet has different areas, so specif...
After reading other posts this seems to be a common issue when upgrading from Office 2003 to 2007. So far after rolling out a few upgrades of 2007 random users are experiencing the following ...
I have a column in Excel where some of the fields have text that is all capital letters such as the following:
NEWBORN DRIVE
I want to change the captial letters to:
Newborn Drive
...
I have a workbook that contains about 20 worksheets. The worksheet names are Report-1, Report-2 and so on. Each worksheet contains a table with Column headings and row data. What I want to...
I want to create a drop down box in excel that would have the user see items such as apple, orange , banana, etc but I would like to have a numeric value assigned to these choices so that I co...
Respected sir
i am using Crystal Report 8.5. I want to Generate report in ms Excel format through vb 6.0
in backend i am using ms Access
Hi
Is it possible to set all the pages in a Multipage control and then
use VBA code to set pages 2 and 6 as visible when needed.
Thanks
How do i read a .XLS file that has been saved as Web Page Type using C#? attached is the File...but when i use "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\data.xls;Extended Properties='E...
hello,
Are there any excel function to cut a substring in a string.
Ex: I have First name and Full name fields, now I want to add a Last name field. Are there any function that can subs...
Need to remove spaces so I can sort the table with over 500 entry's. If look at the image, the cell's with red color is the way they are today, and green is the way i'd like them
Hi, I have a VBA script and it combines different values in a range to match the target value in a cell. For example if the target value is 10 then the macro will comibne the values in a range...
I need to create a simple TCP socket connection to test if the pc is connected to internet. I'd prefer to do it within Excel VBA itself, failing which, an external program coded in Delphi 8.
...
I need a function which checks a string (derived from a range containing game scores like "10,8" or "?,?") to see if they contain a "?". If they do then the game has not yet been played.
I...
Hi
Could one change the fill for a cell using a VBA function. For example, I want with the following formula in a cell:
=SetColor(A1:A5)
set the color of cells A1,A2,A3,A4 and A5 to R...
