excal vba

I am having excel sheet with huge data. I want the vb macros to take out the unique count of Column 'Computer Name' by filtering the column 'Location'. Like: <tbody> Row1 <colgroup><col width="125"></colgroup><tbody> Computer Name </tbody> <colgroup><col...

I want to make a macro/VBA script that will search a single column for separators (dashes), select the rows between the dashes and transpose that data into another worksheet. There are several hundred "records" laid out this way. Ideally, I'd like the macro to find/select the next range and...

Hi Everyone, My first post here, but not the last - I've recently (through work) started getting involved in some excel VBA work, I've had some experience with VBA at uni but not much, more so with Fortran. So I understand generally how things work, but am struggling with syntax. Anyway, what...

Hi there. I would like to have a macro designed. I have 2 workbooks, one having latest information and the other having the information in database already. both workbooks have 26 columns each. I would like to check if a value that exists in Column A of the "latest-information" workbook also...

I need to find a way to find and repalce using VBA so that 00904-0201-61 converts to 904020161 or 12345-6789-11 converts to to 12345678911 by removing the - between then numbers. ActiveSheet.Columns("C").NumberFormat = "@" or ActiveSheet.Columns("C").NumberFormat = "00000-0000-00"</SPAN> do...

I created a couple of functions in a separate module called "Functions" and one for Subprocedures named likewise, both located in the Personal workbook. I had a function called "ConvertCalDate" defined as a date. It worked perfectly fine and I was able to reference it in any of my workbooks...

Thank you ahead of time if you can help me with this. I have information in column 12 that has conditional formatting that turns the text read if certain requirments are not met. I've been trying to write code that goes thru column 12 to see which are in red and then returns the information in...

HI, I need some excel vba examples, where with in the VBA code(Excel Macro) i could call a VBScript and will get some values like filename and directory information from the vbscript and assign it to the variables in VBA code. The basic requirement here is, I need to assign dynamic...