VBA Finding a way around an array error 1004

[AbdulkareemAlhassni]

Hey guys,

i have the following code that i wish to use:

Range("D3").Select    Selection.FormulaArray = _    
     "=IF(INDEX('Raw Data for PR Dist'!R7C5:R100000C5,MATCH(1,('PR Dist SSD Report'!RC[-3]='Raw Data for PR Dist'!R7C1:R100000C1)*('PR Dist SSD Report'!RC[-2]='Raw Data for PR Dist'!R7C2:R100000C2),0))="""","""",INDEX('Raw Data for PR Dist'!R7C5:R100000C5,MATCH(1,('PR Dist SSD Report'!RC[-3]='Raw Data for PR Dist'!R7C1:R100000C1)*('PR Dist SSD Report'!RC[-2]='Raw Data for" & _       " PR Dist'!R7C2:R100000C2),0)))" & _        ""  

the problem is the following:

1) The code exceeds 244, thus i need a workaround

2) i want the workaround to autofill till last row starting Cell D2 till the last existing data in Column A1


This was my first workaround but i can not use it to Autofill or copy paste it till last cell.

Please Login or Register  to view this content.

as the A3 and B3 are not updating as we do down the cells to A4, A5...etc B4,B5...etc

[davesexcel]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.