$$Excel-Macros$$ Sort Hidden and Unhidden Rows

Heed help is sorting hidden rows. Is there a vb macro code that someone can help me with to sort reguardless if the rows are hidden or not.Thanks in Advance!!! -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for vi

$$Excel-Macros$$ Change row color to Yellow, Then Hide Row

Need help with a macro to: If nothing in Column "H" do nothing If Column "H" has a number in it (always greater than 1) Then Highlight entire row Yellow Then Hide entire Row Thanks again for much needed help. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel F

Re: $$Excel-Macros$$ Run code to also include hidden rows

Once again! Thanks so much!! Works like a charm On Sunday, August 26, 2012 11:40:59 AM UTC-4, Don Guillett wrote: > > Change the lookin:XLvalues to xlFORMULAS > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguil...@gmail.com > > *From:* Dick

$$Excel-Macros$$ Run code to also include hidden rows

Is there a way to also include the hidden rows when running code, copy, find, etc This code works great but I would also like for it to copy even though the row is hidden. If I type the same number in Column A, BEFORE it's hidden it will copy across. But AFTER I HIDE that row, and I enter that n

$$Excel-Macros$$ Re: If number matches then copy & paste

On Saturday, August 25, 2012 5:47:36 PM UTC-4, Dick wrote: > > Need help in creating a macro to or formula: > Trying to stop repetative typing. > In column "C" I have a list of different numbers/letters > I would like to when the user types in that SAME number again,

Re: $$Excel-Macros$$ If number matches then copy & paste

s, _ > SearchDirection:=xlPrevious, MatchCase:=False) > If Not mf Is Nothing Then Cells(mf.Row, 3).Resize(, 4).Copy Target > End Sub > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguil...@gmail.com > > *From:* Dick > *Sent:* Saturday, Au

$$Excel-Macros$$ If number matches then copy & paste

Need help in creating a macro to or formula: Trying to stop repetative typing. In column "C" I have a list of different numbers/letters I would like to when the user types in that SAME number again, which would also be in column "C" Copy, the contents that are next the origional which would be col

$$Excel-Macros$$ Copy results from one workbook to another

Can someone help with the following: In one workbook named (Quote) I would like to copy the contents of Columns A and B to another workbook named (Anodize). Where the copied contents from (Quote) would be placed on the next available blank row in Sheet1 Columns A and B. I know how to place a Comman

$$Excel-Macros$$ formatting text box

I have a text box with the following code. But I'm finding it difficult for some people to input the correct time by following the format. Is it possible to have the text box with 3 different entries such as 0/0/0 or 0:0:0. So the curser is set to start at the hour, then automatically tab to the mi

Re: $$Excel-Macros$$ inputbox format

im T As Integer >          T = Application.InputBox("enter number for minute", _ >              "time entry", 0, , , , , 2) >          If T > 0 Then >             Target.NumberFormat = "[h]:mm:ss" >             Target = TimeSerial(0, T, 0) >          End If >

$$Excel-Macros$$ optionbuttons

Why is some option buttons linked to each other and some not? I have 2 that will cancel each other out when the oposite one is selected. Then I have 4 others that do the same but are not affected by the first 2. Thanks for any help. -- -

$$Excel-Macros$$ inputbox format

In Column C I have a format of h:mm:ss. How do I tell my inputbox when the user enters a number such as 10, or 20 etc... that it should be 0:10:0, 0:20:0, etc... Thanks so much for any help at all. -- -- Some importan

Re: $$Excel-Macros$$ Sort

I need for the same records to stay together. rows 2 thru 8, rows 10 thru 16, rows 18 thru 24, rows 26 thru 32 and so on... Once a record is completed, then delete, and then more everything up. Thanks so much for your help! On Dec 5, 8:26 pm, Ken Roedel wrote: > Try this > > Sheet1.Columns(2)

Re: $$Excel-Macros$$ Sort

Thanks for your help. File is John Lathe.xls On Dec 4, 9:00 pm, in.vaib...@gmail.com wrote: > Pl send your excel sheet. > > Rgds > > Vaibhav J > Sent on my BlackBerry® from Vodafone > > > > -Original Message- > From: Dick > > Sender: excel-macros@g

Re: $$Excel-Macros$$ Sort

Thanks for your help. File is John Lathe.xls On Dec 4, 10:14 pm, ashish koul wrote: > can you attach sample sheet.. > > > > > > On Sun, Dec 5, 2010 at 8:11 AM, Dick wrote: > > I have a strange sort question. In column B there is information > > every > > 7

Re: $$Excel-Macros$$ Sort

0 at 10:30 AM, wrote: > > Pl send your excel sheet. > > > Rgds > > > Vaibhav J > > Sent on my BlackBerry® from Vodafone > > > -Original Message- > > From: Dick > > Sender: excel-macros@googlegroups.com > > Date: Sat, 4 Dec 2010 18:41:

$$Excel-Macros$$ Sort

I have a strange sort question. In column B there is information every 7 rows. Then you skip 1 row (Blank) Then there is the same information but with different dates in the next 7 rows and so on. Is it possible once there is information in All seven rows to delete that information and move everyth