Array formula into range of cells

I'm trying to put an array formula into a range of cells ("B2:B10") The formula should return multiple results dependent on the value in cell A2. When I do it the normal way (ctrl, shift, enter) it works ok, but when I try to do it with code it retur...
more »

2017-03-21 23:03 (2) Answers

excel macro to cycle through filtering options

In excel File A, Col A i have family type for a parts list. 0.5V, 2V, 5V,10V,12V, etc in Col B thru K I have some part data dimensions and things like that. I was looking for a way to have a macro run a filter by the values in Col A, then run other c...
more »

2017-03-21 19:03 (1) Answers

Print/Save IBM Notes Email as PDF before sending?

I am using the code below to create and send an email from excel using IBM Notes. I have tried and tried to get this email to save into a folder as a PDF or just print it so i can print it as a PDF. Whatever i try i cannot seem to get this to print...
more »

2017-03-21 16:03 (1) Answers

VBA for loop (text only) - Beginner VBA

Dim i As Integer i = 1 Do While Cells(i, 1).Value <> "" Cells(i, 2).Value = Cells(i, 1).Value + 1 i = i + 1 Loop I am able to loop with numbers, but when I insert text and combined with another cell. The Do While does not loop thro...
more »

2017-03-21 14:03 (2) Answers

skip empty cells in loop

I have the below macro that should highlight cells in sheet2 different from cells in sheet1. It's working well but I have a problem with it highlighting blank cell: Private Sub Compare() Dim shtARng As Range, cell As Range With Worksheets("Sheet1"...
more »

2017-03-21 11:03 (2) Answers

dynamic selection for linear interpolation

I have a function, which i called InterpolLinear Function InterpolLinear(x, xvalues, yvalues) x1 = Application.WorksheetFunction.Index(xvalues, Application.WorksheetFunction.Match(x, xvalues, 1)) x2 = Application.WorksheetFunction.Index(xv...
more »

2017-03-21 11:03 (1) Answers

BeforeClose will not close my Excel-Sheet VBA

So I have been trying to put together a little Excel sheet, that has an entry Log in it. So whenever the sheet is closed, Name, Date and Time are added. So basically I have three macro running, I will only mention two. The main macro will ask if I w...
more »

2017-03-21 09:03 (1) Answers

Finding array data in worksheet values

I have a table sort of like this: Pendergrass (606)-663-4567 Rich (606)-667-4567 Scott (606)-987-4567 Dennis (606)-233-4567 David (606)-888-4567 Red (606)-567-4567 Wendy (606)-765-4567 Todd (606)-677-4567...
more »

2017-03-21 01:03 (1) Answers

Add header row in excel when string changes

I have an excel worksheet that has a column "A" with a string path in it like this: foo\bar foo\bar foo\bar foo\bar foo\bar foo\widget foo\widget foo\widget foo\zelda foo\zelda foo\zelda I need to add a header row before each change in the path so...
more »

2017-03-20 21:03 (1) Answers

VBA Store Color Index in a Variable

My program is supposed to check the colour index of a cell and then based on its colour, it increases a counter. For some reason I don't seem to be able to store the colour index to a variable though. Here is the code: Dim orange As Integer, green ...
more »

2017-03-20 18:03 (3) Answers

Sending a spreadsheet through email vba

Hey guys I have ran into a problem trying to send an email via excel. I am trying to send an email from excel which shows a timetable as shown. On Friday I was able to get the email to send but now it doesn't seem to be working. Maybe its just ta...
more »

2017-03-20 17:03 (1) Answers

Worksheet Change repeating steps

I have reworked this macro for two days in a load of different ways to try to prevent steps from repeating but the range G2 step seems to run 3 or 4 times and the range G3 2 or 3 times. Does anyone have any ideas?? Private Sub Worksheet_Change(ByVal...
more »

2017-03-20 14:03 (2) Answers

VBA macro for Google search

I am trying to modify a VBA macro for Google search. I want the output in excel to be the number of results (hits on Google). I have tried to change the element within the macro to "resultStats" but I keep getting bugs when I am trying to run it. The...
more »

2017-03-20 11:03 (0) Answers

VBA : Change the style of text when sending a mail

I use Excel to send emails using text in a textbox as body. This works fine, except that when sending a mail, it only copies the text's font size, but not its color or style. I did lots of research, but didn't find any solution. Is there a code that ...
more »

2017-03-20 10:03 (2) Answers

VBA - Accessing html tag inside html tag

I'm new to VBA. My goal is to access a site and put my login details into it automatically. This will be the first step into ripping info from reports and putting them in a spreadsheet. I'm unable to show the site due to privacy issues. Work related...
more »

2017-03-20 06:03 (0) Answers