Tuesday, February 23, 2016

Troubleshoot:Equivalence between MyListobject.Databodyrange and Range object Error

Equivalence between MyListobject.Databodyrange and Range object

I am using the following objects in my code :


Dim tblStab As ListObject
 Dim dbrStab As Range


Set tblStab = Workbooks("S1.xlsm").Worksheets("Data").ListObjects("T_STAB")
 Set dbrStab = tblStab.DataBodyRange


My code runs fine with statements such as ...
tblStab.DataBodyRange(rowindex,17)="myinput"


and I was wondering if it is safe to replace every such statement with ...
dbrStab(rowindex,17)="myinput"


I am trying to find my way in the object arena and I am not sure if the Range Object dbrStab declared as above is equivalent to the "fuller" tblStab.DataBodyRange statement.
Is there any catch in this?


Any input will be greatly appreciated.

Solutions to the Problem Equivalence between MyListobject.Databodyrange and Range object

Download SmartPCFixer for Free Now

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Equivalence between MyListobject.Databodyrange and Range object in Windows.

  1. Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
  2. Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
  3. Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
  4. Close the Command Prompt Window because we are done.

Reboot your Windows & see if error Equivalence between MyListobject.Databodyrange and Range object is still there.

Note: Your administrator's password might be needed.

Another Safe way to Fix the Problem: Equivalence between MyListobject.Databodyrange and Range object:

 

 

How to Fix Equivalence between MyListobject.Databodyrange and Range object with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system.  Click Scan, and it will perform a scan for 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 fixed.

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


Related: Anyone Having Trouble Opening Yahoo Mail Through IE8?,0x80070001 Error When Doing Windows Backup,Active X Controls I E 9,After Sending An E Mail,the Lower Right Corner Now Shows, Sending Mail, Rather Than Connecting And Stops Normal Activity Of E Mail Functions. How To Get Rid Of "sending Mail" Notice,Assembling A Manuscript With Multiple Chapters In Individual Files,Printer No Printing From Email,How To Sum Range VBA Depending On Fill Down,Comparision Of Two Cell At A Time & Result In Tick,Windows 7 Pro Freezes Windows Every 60 Seconds When Using Windows Applications,Windows 8 And Pinning On Start Menu,Recorded Dvd Movies And Sound Do Not Sync.,How To Format Fat 32,Simple Table Not Behaving Correctly,Word Starter Open With Previous Document,IE 11 Seems Notto OPEN When Pinned To Taskbar.
Read More: IOMEGA external hard drive [Solved],[Solution] How Convert multiple columns data into one column,Code to add a decimal to the front of a column of numbers [Anwsered],Computer management console access...,[Solved] Can't open xlsx files in Excel 2007 after copying to Windows 2007 computer,IE 8 Need to print youtube embedded static images on regular web pages.,SEARCH INDEX CHANGES WITHOUT PERMISSION,Display Mode Selection and Aero Previews Disappear,SYSTEM_SERVICE_EXCEPTION from netio.sys started 2 days ago for no apparent reason,I have a backup program surviving from a previous computer. How can I remove it?

No comments:

Post a Comment