Hello All,
I haven't been around for a while and I know there have been problems with the board during that time.
I often use "Search New Posts" to get all the latest activity across all forums and hopefully see any replies to threads in which I have posted.........but this doesn't currently...
Hi Forum,
Need some help here with VBA automation.
I have a macro which captures data from an excel range and converts it into a PDF to then be sent via email through Outlook.
However, I would like that at time of capture of the excel range, if I could use VBA to customize the PDF in which...
Hi everyone!
Just watched the video on YT: https://www.youtube.com/watch?v=Wl1qFRI5u5Q&t=52s
and was excited by features, provided by this solution.
But, then I started to find installation files and docs via Google, I had find nothing.. :(
Also, on this forum I have no information about this...
Hi All, Been searching the forum and trying to use various posts to compare 2 workbooks in excel, both same format and same line / rows .
is there a macro in the forum that can ask you to select your first file, then second and then compare and highlight the changes on the latest file or in...
Hello, I am trying to modify this VBA to exclude the ".txt" from the sheetname after import - but not sure how to that, is it easier to just add a line to remove the last 4 characters from the sheet name after import is done? thanks
Dim xWb As WorkbookDim xToBook As Workbook
Dim xStrPath As...
Hi
Since I am less so familiar with this statement, then I can not do much to do a series of tests with this statement. let's say there's a code like this
If Not X is Nothing Then
What does this code mean.
Is there anyone who can help me explain it, and give me a little example using this...
Changes were made this weekend to speed up the forum. If you notice any unusual slowness (usual would be queries, unusual would be posting or opening a thread) or errors, please post here, with as much error information as possible. For speed issues, please note, if possible, the number of users...
Hello All,
I am comparing two sheets. Changes should be saved in the new sheets. If there are any new lines, add, removed,
changes
I got one information from you tube, however when I try it real time scenario it not working.
Please advise if anyone from the forum would be able to help me...
Simplified version so it makes sense.
I have two columns of data. In the first is a series of numbers. In the second is a series of numbers (all integers between 1 and 10) that is generated independantly of the first.
At the bottom of the first column, I want a formula that only sums the...
Does anyone know a good forum for help on Microsoft Word? I am utilizing my new found skills with Excel and out-sourcing it to Microsoft Word, but naturally running into troubleshooting issues. c'est la vie.
I have sent a private message in this site, and today the msg i sent yesterday was marked as yesterday, I am in Asian, could tell what's the reason for that?
As a new user, after i joined a thread or post one here, whenever i log on it again, i couldn't find the easy access on a panel, is there a place somewhere for me to access my related thread?
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.