Following from this thread:
https://www.mrexcel.com/forum/excel-questions/1114405-collections.html
I was told this piece of information:
Syntax
...
For Each element In group
...
element ... For
collections, element can only be a Variant variable, a generic object variable, or any...
Hello there, this request is far beyond my capabilities of excel and I'm hoping that it can be done.
I have a dataset as an example below:
<tbody>
A
B
C
D
E
1
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Email address
<style...
Good Evening,
I have a Case code question.
In having:
Case "Tab Name"
Now the
represents just that, the name at the bottom of the tab of which is the actual name of the worksheet.
Is there anyway to specify this in a generic fashion?
For example...
My company has upgraded to Excel 2019, and I previously used a morefunc plugin which no longer seems to be compatible. Specifically, I'm getting errors with SHEETOFFSET, which I believe was part of morefunc. I have found a few examples of SHEETOFFSET online, but they are all different, and so...
Hi All,
I'm trying to load data from excel to sql server. For this I created an insert statement which is very generic means this statement can be used for any table. I just have to change the name of the sheet and it will automatically pick up the names of the columns and their values from the...
Hello all,
I've written a formula that removes the time stamp and time zone for a date value. Wherever the date field is blank a generic date is placed there '01/00/1900'. I would like to replace the generic dates with a blank instead. The formula I'm using is...
Hi
I have a macro which emails a report out to users based upon various details which is working as expected. The one issue I have is that I would like to be able to select a value in a cell that is the email address the message is to be sent from. At present the email will always come from my...
Hi
I get this message on a number of workbooks and want to try and stop them, anyone know why this happens and how do I stop it
The name 'Generic name' already exists. Click Yes to use that version of the name, or click No to rename the version of 'Generic Name' you're moving or copying
I...
Hi All,
I need to amalgamate some data I've got but my minds gone completely blank. The name is all one person but I need all the types to come into one Cell. I'd normally use concatenate but some people haven't had all the tests so the data isn't consistent. Some have only had 2 parts..I...
Hello,
I would really appreciate some help.
I have a spreadsheet with 19 columns.
In column A there is a generic code
In Column K there is another generic code
In column D there is a quantity
A D K (qty)
ABC 1 123
XYZ 2 123
DEF...
I have a list of comments that is manually entered by multiple people. I need to find which is generic in nature. Is this possible in excel. i know we cannot use any formula for this. Is there a way to do this using macros?
I have a workbook with multiple sheets of data and all are in the same format (data with the same headers in columns A:I). However, the number of rows with data is a variable - different for each sheet.
I want it to sort column A ascending and column I descending, and then remove duplicates -...
This is likely to be an easy challenge for most of you experts: I have a very helpful macro which I generated via "Record Macro". I want to be able to run it on ANY similarly structured worksheet. Alas, it appears to have the original sheet name embedded (see code below). Can I replace the...
Hi all,
I want to create a macro button to sort whatever range I have selected according to column D.... For example, I want ONE sort button that works when I select B7:H9 and it to also work when I want to sort B10:H11.. I do not want it to sort the whole table at once, or it will pull...
Let me describe my situation.
I have 2 xls files. Lets call them info<date>.xls and database<date>.xls
I have to update both files on a weekly basis.
Here are my current steps:
1. Manually update stuff in info<date>.xls and save with today's date, leaving the older file unchanged for archival...
Hello,
Is this possible? I know how to do it if I'm trying to remove specific row fields by name, but is it possible to have a macro just remove all row fields regardless of name?
Thanks!
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.