unable to retrieve data

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:26 AM.