Trying to convert from C# to VBA what am I doing wrong here? I’m trying to assign a value to the row of a dynamic date column, the original C# code worked. C# - row[new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(counter).ToString(“MM/dd/yyyy HH:mm:ss”)] [image]

Hi, Sorry, I had a little misunderstanding. As it seems bug, for now, can you try the following as workaround? tempStr=new DateTime(DateTime.Now.Year,DateTime.Now.Month,1).AddMonths(1).AddDays(counter).ToString("MM/dd/yyyy HH:mm:ss") Then row(tempStr) = 0 Regards,

Invalid L value?

Help Activities

lmoham (Lmoham) August 2, 2021, 3:49am 3

Hey again

I’m not quite sure I follow you as the code worked previously, I’m currently trying to convert everything from C# to VBA so I copied all the activities over from a C# project.

There appears to be no errors in the C# project whatsoever so I’m confused as to what I’m doing wrong

Assign: Exception has been thrown by the target of an invocation assign date row

Topic		Replies	Views
Assign: Exception has been thrown by the target of an invocation assign date row Activities excel , activities , question	4	1045	August 6, 2021
Adding Data to a specific column which has a dynamic column name and position in Data Tables Help datatable , activities , question	2	1747	January 4, 2020
Error in handling Date Time Values Studio excel , activities	5	1224	September 14, 2020
Date conversion from excel column Help excel , activities	14	2573	September 7, 2019
How to save values as date time in For each row in datatable? Studio activities , question	6	287	July 27, 2023

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Invalid L value?

Related Topics