Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: fuzzhead1506
- Order by date
-
format rows of the same type (in while loop?)
thank you thank you thank you!!!!!!!!!!!!!!!!!!!!!! =)- fuzzhead1506
- Post #17
- Forum: VBA Visual Basic for Applications (Microsoft)
-
format rows of the same type (in while loop?)
ok.... prolly the last question! you have been so helpful btw I am trying not to delete a set of cells at the end of a column that is variable. I think I need to use the xlUp and offset functions in order to reference what I wanna do. I am guessing it would look like this...- fuzzhead1506
- Post #15
- Forum: VBA Visual Basic for Applications (Microsoft)
-
format rows of the same type (in while loop?)
I would like that line to reference the first cell in the row as there is now a filter that shows the rows only with the SSN header in the first cells for the entire column - so you were right. However, the macro runs and gets the same error for this line of code too...- fuzzhead1506
- Post #11
- Forum: VBA Visual Basic for Applications (Microsoft)
-
format rows of the same type (in while loop?)
Sub Align_EE_Column_D() ' ' Align_EE_Column_D Macro ' Format tab when "Employee" header appears in column "D" ' ' Keyboard Shortcut: Ctrl+Shift+D Range("F3:F28").Select Selection.Delete Shift:=xlToLeft Range("G3:G28").Select Selection.Delete Shift:=xlToLeft...- fuzzhead1506
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
format rows of the same type (in while loop?)
First and foremost thank you for your help. Secondly, I think I have decided to go with the second set of code as I also have an oddball row at the very end and very beginning of my spreadsheet. Unfortunately, when I run the macro, I get an error that doesn't that says that the object...- fuzzhead1506
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
format rows of the same type (in while loop?)
Hi, I am new to vba and in an excel spreadsheet I'd like to search my sheet for all rows of the same type and format them in a way that would allow the sheet to be read a little easier. I think a while loop is the best way to do this is a while loop, but if someone has a better idea by all...- fuzzhead1506
- Thread
- Replies: 16
- Forum: VBA Visual Basic for Applications (Microsoft)
