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.
Hello Krishnan I am not sure which variable contains the vlookup. To resolve this, change the appropriate line below. If...
Hi there.. I am very new to VBA, I was trying to paste formula in cell A2 to alternative column cell like – C2,E2,G2 and so on.. can you please help with that
Here is a simple copy and paste from cell A1 to D1 using vba
Sorry that’s A1 to C1
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).