Nice to subscribe your channel :) I have been learning many things from you and there are many great technics in this video.I have never used these in my life but now i learned them :) Thank you so much and best regards!
Thank you for very use full tutorial. I tried this formula and only sometimes I get an error Type mismatch! : Range("A2").Value = Range("C5").Value & " " & Range("C6").Value whixh C5 is a number and C6 is a text.
Try using Cstr before the values of the cell references so that all different data types gets converted to String(similar data) and then concatenation will be done
Hi Andrew, what do we need to do if we do not want to activate the library reference, then do we need to follow the concept of "Create Object" and then prepare the script accordingly ?
Hi Amit, yes that's correct! So instead of, for example: Dim fso As New Scripting.FileSystemObject Dim ts As Scripting.TextStream You would have: Dim fso As Object Dim ts As Object Set fso = CreateObject("Scripting.FileSystemObject") I hope that helps!
How can you do it lets say you want to group the same genre but want the whole row to show all movies in one cell grouped but only show the genre once in one cell.. so List of movies under the Title but the rest only say what it is with one word. Lets say same genre n date n director. Only say it once but gives you a list of all the movies that have all this the same? Hope that makes sense.
Very useful video. Thanks Andrew
Nice to subscribe your channel :) I have been learning many things from you and there are many great technics in this video.I have never used these in my life but now i learned them :)
Thank you so much and best regards!
Thanks Andrew!
Niec video......
Thank you for very use full tutorial. I tried this formula and only sometimes I get an error Type mismatch! : Range("A2").Value = Range("C5").Value & " " & Range("C6").Value whixh C5 is a number and C6 is a text.
Try using Cstr before the values of the cell references so that all different data types gets converted to String(similar data) and then concatenation will be done
Hi Andrew, what do we need to do if we do not want to activate the library reference, then do we need to follow the concept of "Create Object" and then prepare the script accordingly ?
Hi Amit, yes that's correct! So instead of, for example:
Dim fso As New Scripting.FileSystemObject
Dim ts As Scripting.TextStream
You would have:
Dim fso As Object
Dim ts As Object
Set fso = CreateObject("Scripting.FileSystemObject")
I hope that helps!
Sir,
How can I modify font size and font color for a Label added by Set A1 = Sheet1.Shapes.AddFormControl(xlLabel, L1 + 2, T1 + 2, 15, 15) command?
How can you do it lets say you want to group the same genre but want the whole row to show all movies in one cell grouped but only show the genre once in one cell.. so List of movies under the Title but the rest only say what it is with one word. Lets say same genre n date n director. Only say it once but gives you a list of all the movies that have all this the same?
Hope that makes sense.