Recent content by pangx623

I'm having trouble making this work, Does anyone know why it's not calling the variable? Dim rngCells1 As Range Set rngCells1 = Range("A3:A13") Rows("3:13").Select Selection.Insert Shift:=xlDown Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select...

I'm trying to write a loop in Excel, the trouble i'm having is trying to cut and paste the records from each loop to another excel worksheet without overwriting the data, For example: 1st loop cuts and paste 5 rows/records of data from "sheet1" to "sheet2", 2nd loop cuts and pastes 5...

This works, thank you!!!

Please help.. I'm looking for a formula that subtracts the number of months from a date using the edate function. example: Date = 04/30/2007 - Cell A1 Credit = 4 - This cell is an integer - Cell B1 The difference should return 12/31/2006, but i'm getting 12/30/2006? I believe it's caused by...

This is exactly what I was looking for. :D Thanks to everyone for all the great info.

Hello everyone, I'm encounter a problem trying to write a code. EX: Date Months_to_credit Final_result 01/31/06 4 10/01/05 02/28/06 6 09/01/05 03/31/06...

Hello everyone, I'm trying to convert data type '20021001' to be recognized as a date. The problem is that the data is loaded as char(8) into the tables and the CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) will not work for me. any thoughts/ideas? :confused:

Thank you. Here is what I ended up doing: month: DateDiff("m",(DateAdd("d",-1,"01/01/2006")),"07/31/2006") Instead of the result 1/1/06 - 7/31/06 = 6 months I took one day off the start day to fully account for all months and thus will return = 7 months. For my first post, I forsee this...

Hello, I'm trying to calculate months not days between EX: 1/1/06 to 6/30/06 I tried to use end date (-) begin date, but is only give me the difference in days. What expression do I use to get 6 months? :confused: