VBA (Visual Basic for Applications) is the dominant programming language for Microsoft Office Applications [Word, Excel, Access...].
0
votes
0answers
7 views
Excel VBA Setting Cell Colour based on range of individual cells
After much messing about and trying to sort this out I am at a loss. I have a C# interop that returns a CSV list of cell addresses. This part works without a problem. I have a method that sets the ...
-1
votes
1answer
8 views
EXCEL 2007 Macro insert x value of rows
Hi i have tried to make a Macro that could insert x number of rows but it won't work.
I would be very grateful for any help! :)
Sub Makro4()
'
' Makro4 Makro
'
' Kortkommando: Ctrl+j
'
Dim Rng
...
0
votes
3answers
15 views
How do I get the index in a VBA For Each Loop (programming with Excel)?
I am working with EXCEL VBA to process some data and here is what I want to make:
In this sheet, I want to create a function "GetDebutDate" that can automatically calculate the first date that the ...
0
votes
0answers
17 views
Cannot unprotect worksheet with below code
Code works fine normally on an unprotected sheet, but when i protect it, it cannot be unprotected by using the below macro. Am i doing something wrong here. Thanks.
Sub macro_01()
Sheets("Keylink ...
0
votes
0answers
7 views
VBA Post file and additional parameters
I use Excel-VBA to automate a login and some clicks in IE.
But when I come to a point where I hava to Upload a file through an field, I don't know how to do this.
I had a look at this site: ...
0
votes
0answers
10 views
How to use SQL Select Query in VBA code?
I have one query of SQL, which I want to put in a VBA code to bring result in Excel sheet.
I tried the code pasted below.
Sub Connect2SQLXpress()
Dim Ors As Object Dim oCon As Object
...
0
votes
1answer
22 views
Excel VBA - Send mails
task to send email from excel.
Below is the example column. How I can get the email value from the loop?
Thanks
Here is my code :
Dim rng As Range
Dim row As Range
Dim cell As Range
...
-1
votes
0answers
25 views
Removing rows from a table in Excel VBA
I'm trying to something simple - delete a row from a table in excel using vba, and shift the contents up. The only reason I am reposting this is that it seems like all solutions already posted deal ...
0
votes
0answers
23 views
Alternates between Error 1004 “method range of object failed” and Error 13 “Type mismatch”
I'm a VB newbie and was hoping someone could help me. I spent an hour reading related questions in the forum, but still have not been able to solve my issue.
I have a list of MRI facilities on one ...
1
vote
1answer
11 views
Attaching a Textbox to a point or line on a chart in Excel/VBA
I was wondering how to attach a textbox to a point or line in an Excel chart for the macro I am working on. I have been using the .AddTextbox method such as
...
-5
votes
0answers
21 views
Code to automatically add new email address to a table [on hold]
I am completely new to VBA so I would be really grateful if you can write a code for me.
It should automatically add to the table “Input” (in File2) all the emails and date of receipt in File1 ...
-1
votes
2answers
18 views
Conditional If statement to set cells equal to 0
I have a spreadsheet that is over 6000 rows and 300 columns. I need to know how to write code in vba that will allow me to read cells in a column and if says "no" then it sets the 3 cells to the right ...
1
vote
4answers
30 views
Excel VBA on Range Error - Quick Fix?
The below code gives an error but when I change the range to .Range(A2:A9999) it works...
But it's ugly. Is there way to grab all the data in column(A) from A2 and down? and copy that into B2?
...
1
vote
1answer
19 views
VBA - Method 'delete' of worksheet failing
I made a VBA program and now that everything is done I need to clean my workbook completely to run the program several times. For this I am using this code:
Sub deleteWorksheets()
Dim ws As Worksheet
...
-5
votes
0answers
34 views
error in a loop procedure [on hold]
I know that this is not what you should do but could somebody please have a look at my question here
Loop increment error
I really need to finish this tonight, and would be very thankful for any ...
