ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   source location and error message 400 (https://www.excelbanter.com/excel-programming/342782-source-location-error-message-400-a.html)

owl527[_3_]

source location and error message 400
 

hi,
I am trying to run a macro and i got the following message:
Microsoft Visual Basic: 400

What does that mean?

Also, I have the following line in my code:
Set rgSource =
ThisWorkbook.Sheets("SG_WarrantRic").Range("ric_ta ble")

how do i find where "ric_table" is? is there a way to search for it?
please let me know. Thanks.

Shirley


--
owl527
------------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=476076


ilyaskazi[_84_]

source location and error message 400
 

On left of Formula bar, there is one combo name box where your cell
address is displayed (something like 'A1' -check pressing CTRL+HOME)

Click on this drop down name box and check your range name. If found
click to locate.


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=476076



All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com