Class is looking for a macro for Excel to answer the above question in VBA, need help with the VBA Macro.

Homework Problem 1: Porous, cylindrica -shaped pellets can be used as a catalyst in a packed bed reactor. The feed material A diffuses into the pellet where it reacts to form products. The concentration of A on the surface of the pellet is C. The rate of the reaction can be described by the expression R = *C, where is in moles of A/volume/time and C, is in moles of A/volume. The diffusion follows Fick's law. If the pellet length- to-diameter ratio is (ID3, the end cap effect can be ignored and all changes are in the radial direction. A steady state material balance results in the differential equation: 1dd - RC = 0 Daparlar Where D is the diffusivity of A in the pellet. We can assume that the concentration profile is continuous throughout the pellet and that at the outer edge ir = R., R = C The usual solution is written in terms of a dimensionless variable: x="0 The concentration at any pointrunits from the center of the pellet, the concentration can be estimated by CEC refore "refer with Write a VBA routine that will calculate C, when p = 0.002.7 = 0.003, P = R = 0.004 to at least the 10,000ths place Data: C = 2.6 kmolni, 1 = 260 kmol/mi/min, D. = 9.5 x 10 m/min. Note: the O-Orger Besse function of the second ling. You conco.cu ce itin Excel using the function BESSELNX. You may check your work using this shortcut cut wont you to use the series solution for the assignment