PDA

View Full Version : Excel Help



Pages : [1] 2 3 4 5 6 7

  1. Animation on Form Control
  2. Get Range Address When Length Of Address Greater than 251 / 255
  3. Differences Among Form's Initialize, and Activate Events
  4. Work Around For Excel Chart Max Series Collection Limit of 255
  5. Trapping Copy To Range Before Copy/Cut Paste
  6. VBA - Secondary axis - CHARTS
  7. Missing MSComctllib
  8. Userform With DataGrid or FlexGrid
  9. Replacing VbTab with Underscore in ActiveSheet
  10. Remove Numerics From Text
  11. Add Control To Right-Click Cell Context Menu
  12. Adding A Menu Bar To A User Form
  13. Find All Cells That Contain A Certain Value
  14. Widgets Used In Excel
  15. Delete Empty Rows
  16. Merge Multiple Worksheets into One
  17. Naming a new WorkBook
  18. Printing Sheets Based On Criteria VBA
  19. First Letter From Words VBA - Acronymize
  20. Hide/Unhide Columns with Listbox
  21. Save File In CSV Format VBA
  22. Overwrite Currently Open Excel Workbook File With A New File
  23. Excel showing "Not responding"
  24. Finding highest value in array
  25. Listview not working in Windows 7 - 32 bit
  26. VBA to Create Grouping (Difficult)
  27. Simplification of IF formula
  28. Add Overs in Cricket
  29. Loop in Array
  30. SUMIFS multiple criteria from same column
  31. Find Value Based On Criteria
  32. Protecting Elements in Worksheets
  33. Self-Learn Excel VBA
  34. Import text file to an Excel file
  35. The Sum of A1 + A2 + A3 + A4 = 52
  36. IF Function with Multiple Criteria
  37. Format Cells Based on Given Input
  38. Spreading a time range (shift time, etc) in columns.
  39. Copy Sheets To New Workbook And Save
  40. Closing Stock Report With Parameters
  41. Copy Existing Sheet, Paste Values from existing workbook into new workbook
  42. VB.NET , C++ or C.NET
  43. Send Lotus Notes Email Using VBA
  44. Lock cells on the basis of date VBA
  45. Allign Waterfall Chart Label
  46. Excel Template With Macro For Sending Mails And Attachment Through Outlook
  47. Find Value Based On MAX Value
  48. Executing XLSM file on a web page
  49. Lookup on Multiple Criteria
  50. Merging Data from many workbooks in to one workbook
  51. Count the occurrences of text, characters, or words in Excel
  52. VBA - Excel: Disable Internet / Google
  53. Split Closed Workbook into Multiple Workbooks Using ADO
  54. How to condense several rows into fewer rows?
  55. Check whether a chart is selected by the user or not using VBA
  56. Find duplicate values
  57. Filter more than one pivot table at one time
  58. How to get the values of a range in immediate window of excel vba?
  59. Insert 'n' number Rows after any specified row no.
  60. Generate random numbers in Excel
  61. Removing Particular value from a Drop Drown form control using VBA
  62. Auto adjust for cells according to value using VBA
  63. Scroll Lock and Unlock using VBA
  64. Need to Bold the Font of a Chart's Axes Value using VBA
  65. Working out of Statistics on Exam Results URGENT solution needed!
  66. Application.ScreenUpdating = False not working
  67. Printing range of sheets in excel or in PDF
  68. Format Cell To Convert Display Number As Billion / Million / Thousand
  69. Set Chart size using VBA
  70. Resize a Rectangle shape according to the total number of row using VBA
  71. Linking Cells In a Dropdown Box
  72. Converting text strings to points
  73. Timer to close excel workbook
  74. Week Number And Week Start Day of Week
  75. List Of All Files In A Folder
  76. Left and Right Mouse Click Event
  77. Opposite of DateAdd
  78. How to completely delete the content of the enire sheet
  79. Sort Data When a Header Is Clicked
  80. Click Run cycle
  81. Need a vba macro which can send mail for particular status
  82. Transposing arrays to the worksheet
  83. Update data from closed workbook with sumif formula
  84. Compare two worksheets and List Differences
  85. Mail Range or Selection using VBA
  86. Get the group of shapes properties(height, width, top, left, right, bottom)
  87. obtain data from 3 input with conditions
  88. compare and get data from many sheets and place it in another sheet
  89. Convert 24 hours to 48 hours in excel
  90. Excel and Outlook Integration For email sending with signature file
  91. Sql Queries For search Update Delete on excel sheet from vba
  92. Capture values from IE page
  93. VBA Function To Extract Decimal Numbers
  94. Split Cell and Lookup
  95. Version 2003 to 2007
  96. Check if file is already open
  97. Replacement for TreeView
  98. Using Selection.Address
  99. Excel Application.OnKey With Parameter
  100. Opening a Pdf file using VBA
  101. Using Office.CommandBar
  102. Using SheetChange
  103. Correlation Map with color codes
  104. Formula Assistance
  105. WorksheetFunction.MInverse Method
  106. SUM with Multiple Criteria
  107. Create a Titlebar less form which can be dragged by Mouse
  108. Scrolling Marquee text on Userform
  109. Bubble Sort Function
  110. Count with Multiple Criteria
  111. Close workbook without warning popup if the flie is read only
  112. Adding Scroll bar to image box in vba
  113. Number to Words (Rupees)
  114. Maximum columns in a ListBox
  115. ThisWorkbook.Path
  116. Extract data using Advanced Filter
  117. Sample VB programs for Starting VB
  118. List Unique Values Using Formula
  119. Generate A List of Unique Values / Unique Array
  120. SQL in Excel
  121. Graphing a bell curve from an Excel data series
  122. Splittting Data Into Different Worksheets Column Wise In VBA
  123. tracking changes and prompt user
  124. Finding Credit and Debit Data and Creating Pivot
  125. Copy selected data to other excel sheet
  126. Display numbers in Lakhs
  127. Lookup Formula
  128. Council to modify code
  129. Checking if range of cells=VbNullstring
  130. Reading Access tables using INNER JOIN
  131. Code executing inconsistent
  132. Navigate Through Web links and get data
  133. Extract multiple data matching with input
  134. Lookup Based on Criteria
  135. Concatinate values in a Range or Array using Native Formula
  136. Hooking up a CHM file to xl2007
  137. hWndForm = apiGetFocus
  138. Calling Function Keys
  139. Assign an event to chart on workbook open
  140. Excel Nested IF 3 Condition Formula
  141. Subclassing TextBox1
  142. Collate Data from csv files to excel sheet
  143. Reading/Saving binary data
  144. Read/write very large xl2007 files
  145. Mailing a Range or Selection in the Body of an E-Mail Message - Help
  146. Align all text in Left and all numeric values in center in a given range using vba.
  147. Copy webpage and paste it as HTML into an excel sheet using vba
  148. Visual Plotter basis given dates and activity
  149. Fetch Data from multiple sheets based on criteria VBA
  150. Pivot Table assistance : (How to use column headers in report filter in PT)
  151. Excel Error
  152. Reverse Vlookup Using Choose Function
  153. Convert Series into Range.
  154. Lookup & countif
  155. work book format
  156. AdvancedFilter
  157. List all the name ranges in an excel sheet with scope
  158. How to enter date in immediate window for debugging purpose?
  159. Modifying DateToWords function
  160. Number to Words (Rupees)
  161. Remove only numeric value in the end of any string
  162. Formatting Problem while copying data
  163. Calculation with different condition in a cell
  164. Fetch multiple values based on criteria
  165. Data sorting & Graph making according filters
  166. Combining data of Two Array or Range
  167. Handling string in an array of length greater then 255 in excel
  168. Get Name List of All Open Workbook Files
  169. Speed up Loop VBA
  170. Tooltip for Listbox selection - different per selection
  171. Get the last updated file name.
  172. Transpose data into Rows
  173. Display numbers in Lakhs
  174. Create list with arrays
  175. Message Box Before Saving Document
  176. Displayin Date/Time in "original" time zone
  177. Count no of cells containing date
  178. Info: different Value !
  179. Get corresponding text
  180. Start & End Number Further Converted
  181. Import data from website
  182. export all worksheets to separate csv files
  183. Return blank cell instead of zero using GETPIVOTDATA (Excel for Mac 2011)
  184. Count consecutive value in a range using formula
  185. split data into multiple workbooks with 3 conditions.
  186. Insert Picture In Chart Fill Area / Plot Area / Format Area
  187. Loop and Check For Values In Entire Column in Excel
  188. Avoid flickering in excel
  189. Passing a UDF as return type
  190. Send Multiple Attachments Through Outlook Using Excel Template
  191. compare column a to b and b to a
  192. Sum values based on multiple criteria
  193. Volatile Function To Update Or Refresh Only Once
  194. Trim Text after 3rd Underscore but retain format
  195. clearing contents of array of ranges using a single line of code
  196. Creating Chart (Line) using Array data, not ranges.
  197. convert/export excel 2007 chart to powerpoint editable chart
  198. Speed up excel to word VBA
  199. VB code to Run formula untill blank cell
  200. Unable to set the visible property of the worksheet class
  201. SUM Value With Multiple Criteria In Same Column
  202. UsedRange Not Working As Expected
  203. Custom Spin Button Based On Values Passed From Array
  204. Absolute Calender Program!
  205. VBA Code Works Only in debug Mode.
  206. Split data based on criteria
  207. Amount to Words [EXCEL 2007]
  208. Split data
  209. Excel Datedif - Days of February
  210. Find Color in the string using formula.
  211. Counting Columns of range having value greater then Zero
  212. What is the meaning of this formula?
  213. Transpose Multiple columns data into multiple rows
  214. Need Help Empolyee Attendance tracker
  215. Highlight Sequential Cells That Sum Up To A Value
  216. Print Selective Area
  217. Delete Sheet If Contains
  218. How To Create Executable COM Add-In
  219. Separate text with comma
  220. Consolidating Excel files according to Row Heading.
  221. Send Outlook Email With Word Document
  222. VBA editor auto-deletes spaces at the ends of lines
  223. Protect Excel File From Opening Only In Designated Computers
  224. Numbered column in vba
  225. Extracting Unique Data
  226. High Lighting Current Date In employee Attendance
  227. Pivot Table Count No of Items per Category
  228. Macro to create files as per the contents in a column
  229. Pivot Table - Volume by Day and Half Hour
  230. Chart Summary help
  231. comparing two list of datas in excel and doing conditional formatting
  232. Pivout Table group specific period
  233. Import html source of url list in each cell
  234. Adding values less than zero
  235. Vba scripting dictionary help
  236. Passing Parameters Less Than Greater Than Or Equal To Not Equal To
  237. Auto Unique List
  238. Complicate Excel question?
  239. Color Cell Fill With Conditional Format When Value Less Than Or Greater Than X
  240. Sending E-mails w/PDF Attachments via Command Buttons in Excel
  241. Help with a Vlookup and SUMIF
  242. How to Extracting dates and days between 2 dates.
  243. VBA Code to Extract data
  244. How to Lock or Unlock row basis previous cell input?
  245. Macro to export sheet as CSV
  246. Validating 2 Columns using excel VBA
  247. How to track user activity using a macro?
  248. VBA code to copy data from source workbook
  249. Question on UDF LookUpConcat
  250. on workbook open, form optionbutton loses position when unhidden