Hello All,
I've been working on a project and I'm stuck when it comes to converting an Excel Formula into a VBA script.
I've decided to automate a bit of a program, so Yint is the beginning point, and Yfin is the ending point.
The Excel Formula is...
So I have some code that basically does an advance search and checks for the search to be complete and then prints it to the immediate window. Its basically an example modified from microsofts example for using advancesearch function. The error I am tripping is when i set my class application...
Yes,
I believe ive done it.
Anyone got any comments/queries please say.
Function MOVEME27(a As Variant, b As Variant, Optional CELLR As Variant, Optional cellq As Variant) '21/05/2018 works copied to ar4
'' 03/06/2019 23:30 was cellr as range , cellq as range - changed to variants
Dim...
Hi all
I'm new here, and have been unable to find a solution to my specific query online or in forums, so I hope somebody can help me. The problem is with Slicers. I work in construction, pricing up potential projects. We produce a 'Report' from our software and I have manipulated this data...
<tbody>
Hello there,
I have a worksheet where I'd like to add 1 year to the Date column and add 1 to a number inside some text in another column.
The Date column, I have sorted, but the number inside text is the worry.
My Col "K" has entries like '12/09/2019' & '17/10/2019'.
Col "L" has...
Hi there, I have a series of sheets which I have been transposing the contents of to a text file. I have a series of subroutines which 'append' each sheet contents to make a master text file.
This has all been working fine, but I have just noticed that it has been failing to append certain...
Hello guys!
I would like to insert a formula to a cell with a macro, but it doesn't work.
Here is the macro:
Sub Macro1()
Dim oszlop As String
Dim fuggveny As String
Dim fuggveny2 As String
oszlop = "D"
fuggveny = "=IF(ISNA(VLOOKUP(Work!" & oszlop & "2;Work!" & oszlop & ":" & oszlop &...
Hello,
I am passing data between Excel and SAP.
I have this:
OperationPrint = session.findById("wnd[1]/usr/tblSAPLCOIHTCTRL_5000/txtRIPRT1-VORNR[1,0]").Text
which works fine. However I need to loop the row number (LineNumber). This is the code I created:
OPLineText = Chr(34) &...
Sub PreAudit()
Dim ptc As Range
Dim ften As Range
Dim dollars As Range
Dim dollarsr As Range
Dim ascalcr As Range
Dim asvarr As Range
Set ptc = Range("A1:AZ1").Find("PreTenCont").Offset(1, 0)
Set ften = Range("A1:AZ1").Find("fte num").Offset(1, 0)
Set dollars =...
I'm making a little script to search multiple locations for the same file with different extensions.
I'm opening 3 windows to display the search results but I'd like to have more control over the windows. Currently they all stack up on top of each other and they are showing the large icons by...
Good Morning, Trying "in vain" to show the original file name in the "file name:" dialog box. Can anyone help?
================================
Sub RGH_SaveAs()
Dim FName
thisfilename = ActiveWorkbook.Name
thisfilenameinquotes = Chr(34) & thisfilename & Chr(34)
IniName =...
I have a working Bat file which i run from an image on my userform.
Today i needed to add another image & also a Bat file.
I copied the original Bat file code but made an just changed the path etc to reflect the new programme.
My problem is when i click on the image nothing happens in respect...
Hi
I have a form called Customer Enquiry which feeds into a table called Customerdata.
What I am trying to do is create a search form where I have an unbound text box called criteria to enter the search criteria and a button to click to search the records. I have a further sub form called...
I am trying to use VBA to automatically take a cell formula and convert it to a string that can be used in VBA to place the formula in a cell.
Sorry for my poor explanation.
Basically I want to make a simple tool that someone could type in a formula into a cell, use VBA to convert it to a...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.