range and macro

I would like to name a column or unique numbers using a macro. I tried simply recording a macro (I tried this both as a absolute and relative macro) selecting cell C2 and doing <CTRL> <shift> down arrow. When I tested the macro out it always name a range of cells with the same length of cell...

Hi all, I have a named range in my file which I wish to add to the body of my email, at the same time I want to attach that range as a pdf file (under one code to automate the process). I have used online tutorials and have managed to add the range to the body of the email and have also...

This should be an easy one for someone... I've managed to cobble together some code that does nearly everything I need, except for one lousy thing... I need to add a new field in (S1) lets say FileNm and I need to populate that field from the first record to the last in my file. I have looked...

I'm trying to write a macro (Excel 2007) that will iterate through one column at a time, searching for a value of "n", and output the value from column A to another sheet. I have managed to make it work for one column, but trying to get it to increment through the other columns is proving more...

Hi I need some help. I have data in a column where cell A1 has data followed by multiple cells with no data, then another cell with data followed by one or more cells with no data, and continuing down a particular column. e.g. Real Data (null) (null) (null) (null) Real Data (null) (null)...

I'm trying to create a macro that copies and sorts a table in 2 different places. I recorded a macro that did the trick at first but have come to the realization that since the ranges i recorded are static, than when i move the tables up or down one row they stop working. I therefore created 5...

I have "entries" that consist of a row of data and then a blank row below. The first entry is in A2:K3. The number of entries is indeterminate. I have formatting (borders and such) that I want to copy from the first to all the other entries--A4:K5, A6:K7, etc. My modified code from the macro...

Hi Folks I want to put in a formula in C6 to sum all the data from B10 down to the last row of data. Column B will always start from B10 but has variable data. I tried the following but that only added two rows. Range("C6").FormulaR1C1 = "=SUM(R10C:R[5]C[-1])" The following is a compile...

I have a simple macro I need some help with. I want to spin through a row range of cells (O2,X2) on a specific page. As I spin through, I want to check a specific cell in that range (S2) and see if that cell is either NULL or has a zero (0). If either is correct (NULL or 0) then delete the...

Hi, Once again I again I find myself fumbling with basic VBA. I need to hide or unhide a number of columns on each worksheet of a file but the number of columns is different on each worksheet. I have a clculation in my spreadsheet as follows: ="B:"&SUBSTITUTE(ADDRESS(10,A1+1,4),"10","") This...

i'm trying to develop a formula that helps me mark up parts based on the price range of the part. For example: a) part 1- in cell 1a $.01-$5.00 (parts falling within this range would have a multiplier of 5--- and put that value in cell A10 b) part 1- in cell 1a $5.01-$30.00 (parts falling...