PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 [80] 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166

  1. Solved: Calling a Function and Resize
  2. Solved: inserting date where cursor located
  3. Solved: how to paste only value since there r some fuction in cells
  4. Working with a text file
  5. Solved: Aligning data labels in a chart
  6. translating math formula into vba
  7. Problems with foreach loop in a modul
  8. Solved: finding MAX number and matching symbol
  9. Solved: xlCellType
  10. Solved: Userform & Class Module Interaction
  11. Solved: ActiveCell.FormulaR1C1 dynamic column
  12. Solved: Reading a .csv File?
  13. Help With automatically reading a column
  14. Sum months plus today
  15. Solved: how does xlMultiply work? and can i paste and multipy in one go?
  16. Delete named Sheets if they exist
  17. Solved: Listening to the active sheet's events from the personal macro
  18. Download from Excel via URLDownloadToFile
  19. Excel 2007 Macro Recorded
  20. Solved: Intersect
  21. Formulas
  22. Playing with arrays... sort of
  23. Conditional locking of row
  24. VBA Error help please
  25. VBA to copy 3 worksheets and email
  26. Excel to Word... little help required
  27. Solved: Macro Recorder Code fails
  28. Can this code be simplified
  29. Solved: Using a Date variable in Excel 2007 macro
  30. Excel Macro Help
  31. Selection
  32. Solved: Clear cell contents without deleting formula
  33. Solved: multiple file selection
  34. VBA for multiple excel file
  35. Extract a list of employees according to month
  36. Solved: Probably a quick solution to this! - finding rows
  37. Solved: Delimiting in odd situations...
  38. Solved: Excel VBA
  39. Write a value from a cell formula
  40. Solved: Why is this code simply exiting without reason?
  41. Use of Ajax in an inputbox?
  42. Solved: Hide unhide rows in range
  43. Set StartCell as ActiveCell
  44. Solved: Formula to allocate absolute values
  45. Solved: How to export bookmarks from word to excel
  46. VBA Code Problems with Sending Excel DB through Outlook
  47. Sorting While in .FilterMode
  48. adding up interchanging word in a single cell
  49. Split The Column Data based on first column values using VBA
  50. Solved: How do you clear filter in macro?
  51. Solved: XY chart with values on top of each other
  52. use combobox as history
  53. vba MultiSelect ListBox based on advanced filter
  54. Divide the Column Data using VBA
  55. Solved: Change cell colour if changes made
  56. Multi Select List Box based on Advanced Filter
  57. Solved: Add 1 when copying and linking.
  58. Solved: Error Handling
  59. Help with Syntax Using ADO to Query Excel Worksheet
  60. Solved: Football Team Record Ranking
  61. Solved: Detecting Conditional Formatting
  62. Solved: Removing certain string
  63. Solved: Date as an Index
  64. Executing Macro at Time with Excel Closed
  65. Search Function in a User Form
  66. Solved: Selecting a Range of Rows
  67. Solved: using name in VBA propertys vs Sheet name
  68. Solved: How to create Yes or No Message Box?
  69. Extract a string from a cell
  70. Is this a timeout issue?
  71. Grabbing Data..Excel VBA
  72. Solved: VLOOKUP the Nth Occurance
  73. Solved: Use Vlookup in VBA Code
  74. Excel 2007 macro for comparing multiple dates
  75. Solved: could not set the value property. Invalid property value
  76. Combo Box / List box help
  77. Stop dialog box popping up
  78. Solved: Hlookup and Vlookup problem
  79. Solved: Filter from Drop Down Box
  80. how to change multiple value instead of one value at a time?
  81. VBA Code to know the date of creating a new worksheet
  82. lookup function in VBA
  83. Solved: Events
  84. Need macro to list folder with name and size in excel. Thanks
  85. User form will not allow blank fields
  86. Solved: index/match
  87. Copy & Paste Dates with Macro
  88. Solved: Worksheet Change Event
  89. Solved: Uncheck CheckBoxes if one is checked
  90. Tool or editor require for understanding return value of each argument of so many nes
  91. Month selection
  92. Set trial period for use of your project
  93. ِAccepting new repeated entries or not
  94. Solved: Avoiding errors in formulas
  95. Problem: ClassFactory cannot supply requested class
  96. Confused About Run-time error '1004': Application-defined or object-defined error
  97. Capturing UNDO Stack
  98. con.open error message data source name not found no default driver specified
  99. coloring similar cells in values in the same column
  100. Create school timetable by vba
  101. Copy contents from various excel files in a folder and merge
  102. Sum of Cells Within the Selected Range (vba)
  103. Solved: 1004 error
  104. Open and copy/paste data to same row...
  105. Solved: SUM(IF with an OR statement produces incorrect results.
  106. Solved: auto run the macro
  107. Solved: VLOOKUP Question
  108. Solved: Count an array of data based on Sum
  109. Solved: Putting a slash between numbers and text
  110. Copy row to the duplicate row - Macro
  111. Exchange (part of) file name with a cell ref in Vlookup formula?
  112. combobox generate another combobox
  113. Solved: Changing default weekday
  114. Solved: vba vlookup fix
  115. Bookmark Runtime Errors, 5941 and 462
  116. How to compare two same files
  117. combobox generate another combobox
  118. Charting Scenarios
  119. Dynamically creating variables...possible?
  120. Find and Replace Dynamic values
  121. VBA help: need to transfer 130 cells to memory and back
  122. Printing specific records
  123. how do we access a variable declared in one form to another form
  124. Adding a blank string in between
  125. Worksheet event code to copy Formula
  126. Solved: Unmerge target cell
  127. Solved: converting multi-dimension array to single-dimension
  128. How to import XML to excel without the HTML, I think?
  129. Solved: Write to Word from Excel
  130. Solved: Sum an array of data when records are > $xxx
  131. Range References in VBA when Wks Rows/Columns Deleted
  132. Solved: Run-time Error 70 creating application object in Windows 7
  133. transpose macro
  134. Pivot Table
  135. Copy specific multiple groups of sheets to new workbooks
  136. Solved: find first item in column
  137. align input data
  138. Random Sampler Macro
  139. Finding the min or max value in a sub range of a reference.
  140. Solved: SEARCH COLUMN FOR VALUE AND COPY ROW
  141. Solved: Macro to find specified date in a range
  142. How to delete external links excel 2007
  143. Solved: Deleting duplicate data
  144. Defining an array as a range of cells
  145. hyperlink
  146. Solved: Error Setting Selection.Formula in a ListColumn
  147. Solved: extend the border line until desired row
  148. Control on Combobox
  149. Solved: represent column by variable
  150. Problem with UDF Function
  151. Run time error '6'
  152. Update links between workbooks
  153. Find row based on picture
  154. Classes
  155. Need help replacing For Next Loop with AutoFilter
  156. VBA OOp
  157. Assort information in columns from rows
  158. Solved: Deleting Defined Names
  159. Install a new font in Excel
  160. mail item problem
  161. Force enabling macro
  162. Solved: Separating between each two digits
  163. @Wierd Calculation Issue - VBA- Excel (2007)
  164. DTPicker
  165. Changing dates in a cell
  166. Solved: Copy 2 cells with formula.
  167. [SOLVED] Saving a chart to .pdf
  168. Solved: is there any way i can change the WB created date
  169. add item to a listbox
  170. Solved: Total distance and time between two cities in a state
  171. vblf's peculiarities
  172. using vba to copy and paste from a website
  173. Solved: copying value set to variable
  174. Solved: Defining a variable number of arrays?
  175. How to highlight conditional formatting
  176. Listen to double click
  177. Save file as TXT or CSV
  178. Create New tab
  179. Greate ChartLines & Show SeriesPoint(i)Values?
  180. Formula help
  181. how to stop at the last row
  182. Unviewable projects
  183. Sending Excel range to Access; question...
  184. random
  185. Add 1250 textboxes in excel using vba vb6
  186. Get entire worksheet range
  187. Copying a row in Excel using VBA
  188. Solved: Creating a number of workbooks
  189. Solved: Compare Column Data
  190. Transparent Command Button Covers Text
  191. Working with Cell Comments
  192. Solved: Horizontal Sorting
  193. Array Formula
  194. VBA Application to print multiple, user selected files
  195. VBA Function Help
  196. Set Chart Height and Width to Match Page Dimensions
  197. Spedometer Type Chart (Donut) - Help with Formula
  198. Solved: Add from Month of April Onward
  199. Set Properties for Printing
  200. Run a macro at a specific time and day
  201. Formulas help
  202. Messy alignment when copying to Power Point
  203. Unique items in ListBox
  204. Solved: correction
  205. Solved: Producing Error
  206. Compare one workbook with multiple workbooks
  207. Solved: data from txt to existing sheet (only fix my code)
  208. Solved: Select Case
  209. Excel 2007 error with code for creating passwords
  210. Excel Date Problem (XLD!!!)
  211. I expect this is fairly simple...
  212. Automatic Sort On double Click
  213. 2D arrays
  214. Ribbon Object in xl2007 vs CommandBar Object in xl2003
  215. Creating a UserForm Programatically, with Frame
  216. Excel 2007 Unlocking Specific Cells Based on Password
  217. combox transfers data
  218. Solved: Replace carriage return and line feed in excel
  219. Solved: Checkboxes form Form Controls
  220. Need help with some VBA - Probably very simple
  221. Solved: zoom sheet on background
  222. Microsoft listview control 6.0 (SP4) problem
  223. Solved: How to raise/lower the Windows Taskbar with code
  224. Conditionally hide and unhide cell ranges
  225. Solved: Dynamically determine week number and filter
  226. Excell 2007 - select all/copy
  227. What Are the Black Dots For On Excel Worksheet?
  228. Solved: Importing Data from Multiple Worksheets
  229. Filter Fails to Work - Incorrect Format?
  230. copying chart from one workbook to another using VB
  231. Need help with combobox
  232. Solved: Copying data from excel to word
  233. VBA Code to Delete Rows with AWR
  234. Detect changes to VBA code.
  235. UDF Function to refer to the Sheet Name
  236. Write this formula in a shorter way
  237. Reference to different VBAProject
  238. Excel VBA for multiple email on button
  239. VBA: Go Down Page & Add Seperator Lines
  240. Need help with word to excel function
  241. filtering cells based on data in listbox
  242. Data Validation List with no empty cells
  243. Limit cell to numeric values only
  244. Training Educational DVDs for VBA on excel
  245. VBA Dynamically Saving in a Folder Structure
  246. how to search all w sh in WB
  247. Solved: Application or object defined error
  248. VBA Code if a user input in an inputbox causes error in a running macro
  249. VBA Not working in Office XP
  250. Export Excel data to Access table thru TransferSpreadsheet