referencing

Hi, I have created a class module, and it works fine when I call from the VBA project in which I have written the class module. However, I would like to access my class, from other workbooks as well, so I have tried to reference the workbook through Tools -> References. Now I have access to...

hi, i'd like to find a string in a table (e.g., A1:H200). the string can be anywhere within this table. once the string is found, i'd like to get the data from the next cell to the right (e.g., if the string is found in F32, then i'd like the formula to show the content of G32). if necessary...

Hey, i am trying to copy and paste data entered into a cell into another sheet, then moves down a cell via the click of a button, I am aware that this Code ActiveSheet.Rows("1:1").EntireRow.Cut Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(1)</pre> Cuts the whole line of...

Hi, Can anyone help me with this one.... I'm playing around with name ranges in excel and I'm finding it very useful for a task I'm trying to do, but I'm hitting a problem that I can't seem to find a solution for. If I name a range of 20 items in a list starting in cell A6 for instance, and I...

I am struggling to convert some values into other values, depending on what's happened in preceding columns. In the example below, I want to convert any instances of double letters (AA, CC, GG, TT) into either AA or BB. However, the problem is that I want the determinant of whether it's AA or...

First time posting so be gentle! I have developed a worksheet for work which, amongst other things, presents a single embeded chart with log-log scales but which has two series plotted. The first are a number of datapoints (7-15), the second is a reduced data set and is essentially a...

Hi guy's, I’ve got a mini user form that writes to a tab delimited file. I’ve been looking to then load this into a listbox (for future editing use) but the listbox doesn’t seem to see the information as separate columns, I have one piece of code that loads it all into the listbox but as if all...

Hello, I work with a spreadsheet on a daily basis in order to update daily inventory numbers for my firm. The way one sheet is set up is as follows: September 9 Actual Inventory: X (C5) Amount on GL: Y (D5) Difference: X-Y ( E5) September 8 Actual Inventory: X (G5) Amount on GL: Y (H5)...