Monday 26 September 2016

deleting 2 bottom rows of data with macro in excel [Solved]

deleting 2 bottom rows of data with macro in excel

below is an example of data in excel - the last 5/2/2011 record from Wisconsin with 19.88 is in row 39 but the data can End at Any row depending on how much data is pulled in- I need to make a macro that will find that last record and delete the 2 rows below
it - to get rid of the blank row plus the fleetmatic title???
 

 05/02/2011 
291
Wisconsin
169.01

 05/02/2011 
298
Illinois
740.67

 05/02/2011 
298
Wisconsin
19.88


 


FleetMatics v8.0.177 © FleetMatics 1997-2011 [executing time: 0.02] 




thanks so much for helping,
bkel

Anwsers to the Problem deleting 2 bottom rows of data with macro in excel

Download Error Fixer (Free)

Assuming the Fleematic stuff is in cell A2, and you have record data in col B, you can use this line:
Sub DeleteRows()
Range("B2").End(xlDown).Offset(1, 0).EntireRow.Resize(2).Delete
End Sub

  1. Access the files on your computer via MY COMPUTER
  2. Under the C: drive, access the WINDOWS folder
  3. Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
  4. Delete any files within this download folder.
  5. If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
  6. Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.

Recommended Method to Fix the Problem: deleting 2 bottom rows of data with macro in excel:

How to Fix deleting 2 bottom rows of data with macro in excel with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run it, and it will scan your computer. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 2.6.23.40059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.7.62.0.50 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.8.0.2.3,How to Fix Error 0x0000c1f5 SoluciĆ³n?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: [Solved] Default address locations on envelopes,How to Resolve - Dell Vostro 1015 - Virtualization problem?,How to Fix - Desktop icons open Windows Media Player instead?,Tech Support: Delete windows off spare drive,[Solution] defrag Missing!!!

No comments:

Post a Comment