formatting a row

Hi! I'm copying dates to separate them from middle initials that are in the same row. I used GoTo to select only dates, but when I paste them they all seem to change after the first blank. I'm trying to move them 1 row over to the empty cells as you can see in the picture provided. How can I...

I am using the following code to insert rows in two sheets at the same time. However I also want to copy down the formulas from the row above those inserted on the second sheet after the additional rows have been added. Any help would be much appreciated, Sub insertRowsSheets()...

I have the below code to apply formatting to every second selected row. It works when i use Selection.Rows(Counter).Interior.Pattern = xlGray16 but i want to apply different formatting. i want every second row coloured in blue. I have tried the below but it doesnt work. any ideas? Sub...

I have a number of large spread- sheets. I need to format the row height of every fourth row to 24.00 I have the macro below which doesn't work. Can anyone fix it please? Sub Height() X = 0 Do X = X + 4 Rows(X).RowHeight = 24 Loop Until X = 1000 End Sub Thanks Steve..:mad:

Hi I have a spreadsheet table set up as below where in column A I have a date and column B has related text. Jul-16 Text Jul-16 Text Aug-16 Text Sep-16 Text Sep-16 Text Sep-16 Text The table is quite long and I was wondering if there was a way I can apply conditional formatting...

My macro won't work past 6 columns. I found a macro that formats a cell's color based on the RBG values in other cells. I have modified the original code so that it fits my spreadsheet. Original code: Private Sub Worksheet_Change(ByVal Target As Range)Dim rng As Range, cell As Range Dim i As...

I have 5-10 business days to complete a task. I need to be able to quickly see what's open or pending, and I need to be able to easily maintain it. I tried looking up formulas on my own, but after editing the ones I found I kept getting errors or only part of the row was formatted. I tried...

From reading the form I have to admit I'm a little shy to ask these two questions and not feel a little... well, Dumb. First Question: I have a set of data with column headers from A through XX. The data in each row has information about specific events over a large time frame. This data can...

Hi, I'm sorry if this question has already been asked but I have looked through and can't see it. :eeek: I am creating an excel sheet for the men on my factory floor. There are drop down list where they can pick if a task is either "Complete" "Complete (Issue)" "In Stock" "Incomplete" or...

Hi folks, I'm new to this forum and a relative novice with vba so I hope I'm articulating the problem adequately here... It seems like it should be a simple thing but I've spent hours at this stage trying and failing... For each row on the worksheet, columns G and H are populated with either...

I am working on a sheet that subtotals final amount by individual location. I have the code and created the subtotals; however, I need to create a macro that formats the entire row (i.e A10:Y10). I can not have it as a defined row since the row may change day to day. I just need to format the...