Hi,
In my worksheet, I would like to add a macro which does the following at once: 1) refresh the active workbook, 2) clear the contents of a specific worksheet, 3) import columns data from a closed workbook, 4) refer to the path of the closed workbook based on cell data in the open workbook...
Hi all,
I have this formula:
Essentially, when I fill in ANY data or make ANY changes to cell D2, i want the VBA to automatically update the current date/time in cell B1, so I can see the last time I made any update to cell D2.
I can do xOffsetColumn = -2
But this will show the date in...
Hi all,
I have this overview at the moment:
If I manually choose to save my file as a PDF, it works fine and I get just 1 page with the overview above.
However, I have the following VBA code to save my file as a PDF:
Option Explicit
Sub SaveFileWithMacro()
Dim Path As String
Dim fn As...
Hi all,
I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why?
Thank you!
Hi all,
I currently have the following setup:
I have some numbers in column C and D, and I use a simple sum() formula in column B.
However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime.
What I...
christian røssel
code
excel
ezzzzzzzzzzzz
fast
formula
goldstrome
help
hlookup
jonas sværke
lookup
minus
olzenmedz
plus 1
sum
sumproduct
vba
vlookup
xlookup
Hi all!
I currently have this setup, please note that I have hidden all the nonrelevant columns however:
The formula I use is this (thank you @RoryA !)
=IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...
&indexdd
code
column
copy
copy formula
copy paste
easy
fast
formula
formulas
help
hlookup
indexmatch
jonas sværke
madzi
madzi emil grell
olzenmedz
paste
vba
vba code
vba column letter
vlookup
xlookup
Hello everyone!
I create Userform with this tutorial: Fully Automated Data Entry Userform - TheDataLabs
Here is main code:
Option Explicit
Sub Reset()
Dim iRow As Long
iRow = [Counta(Database!A:A)] ' idetifying the last row
With frmForm
.txtNR.Value =...
Hi all,
I currently have this setup:
Formula in full: INDEX('Q4'!$V$3:$V$73,MATCH(1, ('Q4'!$B$3:$B$73=List!$D651)*('Q4'!$A$3:$A$73=List!$N651),0))
My sheet used to be simply called "Sheet1". However, I have renamed it "Q4" now.
I want my formula to pull in data based on the value in column...
I am looking to make a Macro in VBA that when run:
creates a new sheet called "results" after the first sheet (to the right)
on the original sheet search Colum B for if any of an array of words is present in a cell
if it is to select the row and move it to the sheet called results
delete the...
Hi,
Can someone help me with the below requirement.
I have a code that is running fine but I want to place a message box in between to give a break to the code to do some manual updates.
I am looking for code that pops up with a message asking to do manual updates in workbook and with option...
Hello guys, i am a noob VBA user and im looking for a way to convert geographic coordinates (latitude and longitude) to UTM coordinates and vice-versa. In my searchs, i found a JavaScript code that allows me to do that, but i would like and have to do it on the excel, where i have the map of my...
Hi everyone,
I posted a while ago about a workbook I am struggling with. Luckily didn't get any response, because the entire setup need to change.
I need help please!!
Currently estimate sheet is saved as Pdf and excel sheet in a folder. There was a clear contents function as well which I...
I have rudimentary VBA experience, but I have a specific problem which I need VBA to solve.
Here is my best attempt at explaining what I need VBA to do (with some context):
Context on How the Spreadsheet Works I have a worksheet called 'Block Chain' which logs a large amount of data for a...
Hi all,
I have this code attached to a macro:
Option Explicit
Private Const FilePath As String = "R:\LXI_DLL\ZGJ_COMMON\FLD COMP FOLDER\12-FOLDER\TOPIC 2\ATTACHMENTS\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i As Long
Dim ws As Worksheet...
Amateur to VBA and need some help in creating some automated graphs for work.
I ideally need a macro command to delete any existing graph on the page and for a new graph to be created at the same time, for when data is updated within the table. I am comfortable in creating the command button...
Hi all,
I currently have this VBA code:
Option Explicit
Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i As Long
Dim ws As Worksheet
Dim col As...
christian røssel
code
easy
fast
help
hlookup
htmlbody
index
indexmatch
jyggalag
match
olzenmedz
pdf
røssel
røssele
sanoj ekrævs
save excel
save pdf
vba
vlookup
xlookup
xlxm
xlxs
Hi all,
I currently have this setup:
My VBA code is this ( credits to @RoryA :) )
Option Explicit
Private Const FilePath As String = "\\UBSPROD.MSAD.UBS.NET\userdata\t684895\home\Documents\faq folder\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i...
Hi all,
I have this amazing email macro that @RoryA helped me build (big credits!).
He created a nice loop for me that runs all subjects in an email meaning I can email as many email addresses as I want at a time.
However, when I run it now, it converts my text into numbers for some reason...
Hi all,
I have a sheet with an email in cell A64. I am trying to create a macro that will send an email to this email, but when I click my macro I get this error:
and debug highlights this:
Did I not do it correctly? What do I need to fix?
Thank you all!
BR.
Jyggalag
Hi all,
I currently have this code:
Option Explicit
Private Const FilePath As String = "\\COMPANY.MTJG.COMPANY.NET\userdata\t6853532895\home\Documents\TEST folder\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i As Long
Dim ws As Worksheet
Dim...
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.