The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft. The version independent Tag is "excel". If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.
1
vote
1answer
12 views
How to select a cell when radio button is TRUE in excel
I have a radio button with YES/NO option.
What I require is that another cell gets activated/highlighted ONLY when radio button YES is clicked, and not when radio button No is clicked.
For example:
...
0
votes
0answers
15 views
Excel 2007 - find and replace multiple columns
I want to be able to find a cell in a single column, and replace the cell in that column as well as the cell in the column to the left. For example, say I'm searching column D for "XXXX" - I want to ...
0
votes
1answer
21 views
VBA Macro If cell found in multiple cells then
i need help with the below if then statement. will try and explain as best as i can.
cells E21 and F21 is merged and the value varies. i have a list of numbers underneath each other from o1 to o100 ...
0
votes
1answer
17 views
excel: generate missing years of year range into one cell
I have a script that generates the 'gap' years within a year range (year_start <-> year_end - separate inputs) i.e. for 1997-2002, the script generates the following:
1997,1998,1999,2000,2001,2002 ...
0
votes
0answers
4 views
Excel 2007 updating Sharepoint 2007 list not working
I've been searching all over the Internet for a solution to link an excel file to a sharepoint 2007 list and be able to update the list by modifying the excel file. As far as i read Microsoft droped ...
1
vote
3answers
24 views
Import and Run Macro from text file
I'm trying to simply import a test macro into my current Excel Workbook. And then run the macro. I'm on Excel 2007. I'm getting the error:
Run-time error '1004':
Cannot run the macro 'DoKbTest'. The ...
0
votes
1answer
20 views
VBA Pictures don't show in Excel 2007
I am confronted with a strange problem which occurs under Excel 2007.
I have created a document with 1000 rows (different products/ article numbers) and fetch the product pictures from the net with ...
1
vote
1answer
13 views
excel: generate missing years in year range either in VBA or function
I've been searching for hours for a function / vba macro solution to my problem - unfortunately to no avail... Maybe you guys can help?
I need to generate the 'gap' years within a range (year_start ...
0
votes
3answers
20 views
Ms Excel “Next without for”
I no this question has come up numerous times, I have read through them all and have come across this problem in my code before and have been able to solove it.
If count > 1 Then
For ...
0
votes
4answers
47 views
Delete entire row if cell contains the string X
I am new to VBA and I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word none. The table contains 5000+ records and ...
1
vote
0answers
8 views
C# - excel automation code compatibility - Excel 2007 vs 2010
My application creates Excel reports using automation in Visual Studio 2010 C#. Currently I use Excel 2007, but sooner or later I have to upgrade the environment to Excel 2010.
Is it unlikely that my ...
0
votes
1answer
9 views
Excel importing from CSV adding additional column
Hi I have a CSV file and the first field is date.
I'm imprting this csv file using Data->Import from Text
When I do that it's adding an additional column at the left.
I do not want it to add ...
0
votes
1answer
29 views
excel - Loop through worksheet
I have never used Marcos in Excel before only in Access. What I want to do is loop through the worksheet and where column X and Y are not null extract the information into a new worksheet. But row Y ...
0
votes
1answer
18 views
How to perform 'insert rows' instead of 'copy rows' using CopyFromRecordset(excel vba)
I am new to excel VBA. I have a requirement where I have to copy table values from sql server 2005 to an excel worksheet. I have googled and written a code for the above requirement (listed below).
...
0
votes
0answers
24 views
Preparing a Mail Merge Table with a macro (Office 2007)
I am trying to figure out a way to automatically prepare a mail merge table using a macro.
I have an excel worksheet with 25 tabs. Each of these tabs is formatted identically. One of the columns is ...
