variants

Hi All I've run into a problem, clearly I am doing something wrong! I am trying to set a range using both columns and rows as variants. Please see code below. Any help, much appreciated. Best, Mizogy Dim FirstRow As Variant Dim LastRow As Variant Dim ColumnStart As Variant Dim ColumnEnd As...

Hello. I desperately need some help with a csv file I need to create to upload products onto shopify. The aim of the game is to sort through the 22 000 lines of data, in order to create a new list which contains maybe 10 000 products with TAGS. This part I've done. (The other 12 000 lines are...

Hello. Hope you're all well. I desperately need some help with a csv file I need to create to upload products onto shopify please. I've got 22 000 lines of data to work through and although I'm using a lot of formulas to get the format right, I'm struggling with the last bit and it seems the...

Hello can somebody help me whit this: I need a data criteria for : When i search in column AF the filter to copy from column AO TO COLUMN CP ( AO,AP,AQ,AR ETC) only the filled cells and for AO to modify the text to "#" and then to export only the last letters as you can see in this example (blue...

Hello at work we are using one program that basicly tells us what kind of variants to use for some specific objects for example : https://imgur.com/a/ug8OcaT The macro needs to copy from column : AO(V1) to CP(V54) [AO,AP,AQ,AR,AS....ETC] only the last three numbers and then only the last letter...

I am running a subroutine that uses the resize method to expand the output values of two variants. I end up with a blank first column and a blank first row from the output range cell with the first set of output values. With the second set of output values I receive a blank first row. It...

Hello, I would like to create a macro to find and replace parts of my model with data that the user chooses with input boxes. i have used this method before and it works well, there is just a missing link between the Input Box and Replace function Sorry if my formatting is not perfected this...

Hello, I'm new to VB, so any pointers (beyond my specific question) are certainly appreciated. I need to: [1] compare (row) ranges across two columns with an unequal number of rows (column A [number] to column C [number]) [2] save each result of [1] where there was a match in column B [3] for...

I am referring to http://support.microsoft.com/kb/213798 and have the following variation on the theme: Public Sub Demo() Dim i As Integer Dim htable As Variant Dim h As Range Dim ws As Worksheet Set ws = Workbooks("Demo").Worksheets("Blocks") Set h = ws.Range(ws.Cells(2, 1)...