Search:
Type: Posts; User: MartinLiss
Search:
Search took 3.86 seconds.
-
It's VBA code with two versions. Put either one in a code module and see what happens. You can also search VBForums for 'soundx' and probably find an answer. BTW, what exactly happened when you tried...
-
Please see this explanation.
https://www.source-code.biz/snippets/vbasic/4.htm
-
You guys may not have noticed, but this thread is 14 years old.
-
I've found a completely different way to do this.
-
I have this macro which is supposed to copy all yellow-colored cell to Range("A1") in the destination worksheet and I'm using autofilter since there are > 100,000 cells that MIGHT be yellow. I've...
-
Thanks, but as i mentioned above "...the number of values in the source is variable and there could be a hundred or more values in it, so I assume I would need to use VBA to populate the formula...
-
BTW, I know how to use Join on the source data to produce a string like 1-2-3-4-5-6-7 where the dashes represent spaces, but I could not figure out how to paste that string into the output row...
-
-
The forum is not even allowing me to add a picture so this is the best I can do.
SOURCE
Column A: a date
Column B: 1
Column C: 2
Column D: 3
Column E: 4
Column F: 5
Column G: 6
Column H: 7
-
Here is a link to a demo file. When you click the button two new worksheets will be created from the Database worksheet's data.
https://www.mediafire.com/file/4g5ry2fokq8wqmk/Demo.xlsm/file
-
Zvoni, I am looking to insert blank columns, and the formula in your reference looks promising, but despite what my question said, the number of values in the source is variable and there could be a...
-
Thanks but I know how to use a loop, and what I was hoping for was a way to do it without one.
-
I have a worksheet where B3 is "1", B4 is "5", B5 is "7" etcetera to B8. I'd like to paste those values to another worksheet starting in C5 but with a blank cell in-between the output cells. In other...
-
Thanks then but I'm looking for a VBA solution and I've changed my question's title to reflect that.
-
fafalone, are you talking about VB6?
-
Thanks, but to be clearer, I'm talking about the kind of add-in that can be used in the Visual Basic area of Excel. For example I wrote one for 32 bit where it made it easier for a coder to annotate...
-
Is it possible?
Have you done it?
Do I need Visual Studio?
-
Thank you for your efforts. I resolved the problem which was partially due to the fact that the range should have been 2:2 and not 1:1.
-
In my case I'm trying to hide and unhide columns on the active sheet and not worksheets.
-
In the active sheet I have a button that shows a userform vbmodeless which lists, by name, certain columns in the worksheet. The OK button works if the column isn't hidden but if it is I get the...
-
-
I use a workbook that I created at least 10 years ago. Today I tried to delete a worksheet but all the options to do that were turned off. The things I tried indicate to me that the structure of the...
-
-
In my workbook I have a named range called MonthPoints on worksheet 'Rank' which currently refers to all of column D except for the single heading row. That named range is defined as:...
-
Thank you for doing that.
-
Thanks Zvoni, but the data is in Excel and I don't have access to that data on the web.
-
The range rng3 is a combination of the 3 columns, so I'm not doing 3 lookups per row.
-
Here is that code:
Sub PruneTradeArea()
Dim lngLastRow As Long
Dim lngRow As Long
Dim rngFW As Range
Dim cel As Range
Dim rng3 As Range
Dim rngFound As Range
-
Below is a link to a small(er) sample you can test with. In Module1 you'll find 3 macros:
Test: Your code as modified by me
PruneTradeArea: My current code
Func_Search_Range_With_MATCH
If...
-
Thanks but strColumnValue wasn't defined and when I changed it to strColumnXValue only 25 rows were marked for deletion, where about 60% should have been marked.
-
I have Sheet1 with 55 thousand rows and in another worksheet I have a named range consisting of a single column containing 450 values. Since the cells in F to H may contain multiple words in a cell,...
-
There is a worksheet in my workbook that won't allow me to copy/paste. Other worksheets do. What happens is that after I copy a call and then I right-click, the Paste options are grayed out. When I...
-
I would like to sort each column of table that has a variable number of columns, where when sorting for example column 2, it doesn't affect the sort order of the other columns. In other words I want...
-
I have this code where rngFound is a range. When I run it Excel highlights .FindNext and tells me "Method or data member not found". I've used .FindNext before without any problems. Why now?
...
-
I changed the formulas to non-array formulas and the problem went away.
-
The copying of the worksheets is being done by VBA code.
-
I have a worksheet that has an array formula that begins with
=IF(_xlfn._xlws.FILTER('Support - TAM'!H:L,('Support - TAM'!L:L="Complete")
When I copy that sheet to another workbook it shows up...
-
@OB1: It's an xlsx workbook so I don't believe your suggestion can work.
@Zvoni: Thanks. It definitely is a textbox. However when right-clicking on it I noticed 'Edit Link' which solves my problem.
-
In an xlxs workbook on Sheet1 there is a textbox that when clicked takes me to Sheet2!A1, How is a link like that created?
-
|
Click Here to Expand Forum to Full Width
|