Search results for query: *

Thanks so much, that worked perfectly. Sharon

Hello all: I hope you can help me with the following: In cell C4, I have the following formula: $G$5. Sometimes I need to delete columns G to K, such that columns L to P shifts into place i.e. now becomes column G to K. Can you please tell me why I am getting this error since column G still...

Hi ClFlava Thanks so much, I would pay more attention next time.

Hi cLFlaVA: Thanks, I have made the changes, but I think the way I have it set up is not giving me the exact results. My data has 11 rows. What the code below does now is: in T13 it inserts the word Signature, that's what I want. But then it formats T15 with the All Border and changes the...

Thanks clFlaVA, That worked! If I want to select that cell T... and format it with a row height of say 45 and format it with All borders, I did this, but I am getting a debug in the Line Style part of the code: Sub Signature() Sheet3.Activate If Sheet3.Range("T4").Value > 0 Then...

Hello everyone: I am trying to write a macro: Sub Signature() Sheet3.Activate If [T4] > 0 Then r2 = Rows.Count + 1 [T.r2] = "Signature" End If End Sub But it's not working because I am not sure of the syntax to use. I want to insert the Word Signature in column T of the last row + 2 if T4 is...

Thanks a lot guys. I didn't know the select, activate thing could slow down the macro, thanks for pointing that out to me Skip. CLFlava, thanks for making the macro shorter. Thanks for all your help. Sharon

Hmmm...the page setup thing does not work automatically though, am I right? When I copy and paste data into a particular sheet, sometimes the data rows exceed the print area. I tried the page setup 1 by 1 but it doesn't work automatically. I don't know how the Workbook BeforePrint thing works...

Hello All: Is there a way to make the Print Area cover all the rows with data in a worksheet? I.e. to make the Print Area dynamic?

Wow, Skip: You're right. Thanks so so much.

Yes Skip, I have enough rows. In the sample I am working on, I have 6 "No"s i.e 6 rows. The code works okay by filtering for the "No" in sheet5 and then copies and pastes these rows in sheet3, so the code is working up to the line 'Application.CutCopyMode = False" but the code does not execute...

Hi Skip, I tried the test thing, and yes it gave the the number of the last row, here is the whole code I am running, maybe you can help me find the glitch. I have looked at it (with the little knowledge I have) but can't find anything wrong. Thanks much again. Sub UNonAP() Sheet3.Select...

Thanks Skip, I am looking at the Active Sheet and there is just 1 workbook open. What else could be the problem? Thanks again.

Hi Skip, I hope you're not running out of patience yet after r2 in the code you gave me I inserted [Q4] = r2, and put a break in the rest of the code, but I am not getting any value. How can I make it work? Thanks again.

Hi Skip, Thanks. The data on my active sheet has the header in row 5. Usually, row 5 already has the border around it, but the new rows copied and pasted from another sheet, don't have this border, so I want to format row 5 to the last row if there is a last row with the All Border format. Here...

Thanks so much Skip, I am not getting any errors with the code you provided. But the code to create the all borders is not executing, i.e. my spreadsheet is still not ruled, do you know what's happening? This part of the code is not working: .Borders(xlDiagonalDown).LineStyle = xlNone...

Hi All: I recorded a macro to higlight rows 5 to 551 and then format it. How do I modify this macro to highlight row 5 to the last row and then do the format? Thanks for helping me. SharonMee Rows("5:551").Select Range("B5").Activate Selection.Borders(xlDiagonalDown).LineStyle =...

Hi Skip, Thanks much. the layout you suggested, adds all the days together. I would like each account name to appear under a day group Right now, I am getting Amanda Hortons 16 Speed 5 So, for example, I have 3 hortons accounts 1 with 6 days, another with 5 days, and another with 4 days...

Hello all: I was wondering if I could do the following using a pivot table: the columns in my table includes: Analyst_name Account_name # of Days Amanda Hortons 5 Amanda Speed 5 Eunice Kreme 4 Eunice Crown 4...

Hi all: Please help with the following: I want to create a drop down list in a cell. The values in this drop down also have separate values of their own which will be placed in a different drop down list. E.g. first drop down list: Breakfast Lunch Dinner second drop down list- if...