unable to retrieve data

		Microsoft Office Forums > Microsoft Excel > Excel Programming
unable to retrieve data

FAQ

Thread Tools

Display Modes

02-23-2018, 12:43 AM

RosieSummers RosieSummers is offline

Windows 7 64bit unable to retrieve data

Office 2016

Novice

Join Date: Feb 2018

Posts: 9

if i use the above code

Code:

.Range("A4:W" & Rows.Count).CurrentRegion.Offset(1, 0).SpecialCells(xlCellTypeVisible).Clear

when i type the OFM in the records and run the code, it would produce additional records which are not suppose to be there.

i have attached the excelworksheet below. the error are in red

Attached Files

error.xlsm (23.0 KB, 9 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"word was unable to open the data source" error	meganadand	Mail Merge	6	02-27-2020 11:25 AM
Retrieve the last activated document name.	eduzs	Word VBA	1	08-22-2017 03:11 PM
Unable to open Outlook, receiving message unable to open because (myaccount)@gmail.c	Flyin' Aces Tattoo	Outlook	0	04-20-2013 11:56 AM
Retrieve PPS files	uncledewey	PowerPoint	2	08-10-2012 09:08 AM
Microsoft Scheduler retrieve Calendar data	badda	Office	0	11-22-2009 06:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:19 PM.