Thanks Hyside2, Will try out and get back to you. Regards Ozuberk
This Script has Syntax error - I tried to debug but was not successful
Oh sorry forgot the before and after pictures, Here they are. [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/04/1-1.jpg[/img]
For this to work please add custom format to format cells. Add 13 zeros as the custom format. See pictures....
[img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/04/1.jpg[/img] - [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/04/2.jpg[/img] [code] Sub CountDateTime() Dim ws1 As Worksheet Set ws1 = Worksheets("Sheet1") Dim ltr...
[img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/04/organizegrades.jpg[/img] Sub OrganizeGrades() Dim lastrow As Integer Dim lastcol As Integer Dim ws1 As Worksheet Dim ws2...
Dear Sir I tried the same as follows rng.Copy ws2.Cells(Rows.Count, 5).End(xlUp).Offset(1, -2).PasteSpecialxlPasteValues Run Time error is coming : Object...
Thank you for looking into this, sure i will check get back to you.
I need to add numerous rows (7) of the same data between rows if an item has been added for it to maintain my numbering system. Previously I have been selecting the rows and going copy – insert copied cells and adjusting the data accordingly but this is messing up my borders and is causing some errors in some data being not being replaced with correct numbers/description. I’m wondering if there is a macro I can use to insert multiple rows of existing content? See photo for example (column J has formula H-I)
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).
Enter the destination URL
Or link to existing content